calculated fields in pivot tables
 

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.
--
jag

calculated fields in pivot tables
 

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

"jag" wrote:

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.
--
jag