calculated fields in pivot tables

J

jag

consider the following fields: sales, days in month, terminals.

is it possible to create a calculated field that divides the sum of sales by
the count of terminals??? whenever it try to do this, it uses the sum of
terminals which is not accurate since it adds all transactions for 1
terminal, hence i get a number more than 1 per terminal.
 
E

Eduardo

Hi,
Best thing to do is to have that calculation in the excel sheet and then
bring it into the Pivot Table
If this was helpful please click yes, thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slicers and Calculated Items in Pivot Table 2
Pivot Table Calculated Field 0
pivot tables: Calculated fields among *row* items 0
Creating a Calculated Field in a Pivot Table for same field 3
Pivot Tables, Calculated Fields, and variable denominator 1
Pivot Table Calculated field error 1
Total Not Summing Correctly on Calculated Fields in Pivot Table 0
Pivot Table Calculated Field 0

Top