If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|