Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Fields in Pivot tables - Help | Excel Worksheet Functions | |||
Calculated Fields in Pivot Tables | Excel Worksheet Functions | |||
Calculated fields-Pivot tables | Excel Worksheet Functions | |||
Pivot tables - calculated fields | Excel Worksheet Functions | |||
pivot tables - calculated fields | Excel Worksheet Functions |