velocitygrrl
New Member
- Joined
- Aug 10, 2005
- Messages
- 14
Hi there,
I am SURE this must be possible, but I can't for the life of me make it work.
I have a massive pivot table with three different categories of source data listed and subtotaled by a few different fields. Of the three categories of source data, I want two of them to SUM in the subtotals and one of them to AVERAGE.
I know I can change these settings under "Field Settings" but every time I do so, it wants to change all three to SUM, all three to AVERAGE, or all three to SUM and AVERAGE, but i can't seem to sum two and average one, nor can I hide just the subtotals I don't need.
I hope someone can make sense of this simple yet complicated question!!
Many thanks.
v.grrl.
I am SURE this must be possible, but I can't for the life of me make it work.
I have a massive pivot table with three different categories of source data listed and subtotaled by a few different fields. Of the three categories of source data, I want two of them to SUM in the subtotals and one of them to AVERAGE.
I know I can change these settings under "Field Settings" but every time I do so, it wants to change all three to SUM, all three to AVERAGE, or all three to SUM and AVERAGE, but i can't seem to sum two and average one, nor can I hide just the subtotals I don't need.
I hope someone can make sense of this simple yet complicated question!!
Many thanks.
v.grrl.