Hello,
Is it possible to do % in pivot tables. I thought the calculated field was a way to get around % in pivot tables... For example, if i have the following pivot table:
Inv$ Total Sell-Thru Region DC
63,347 17,421,341 XXXX XXXX
1,809,608 99,536,632 XXXXX XXXXX
My goal is to get a percentage of Inv$ of Total Sell-Thru, therefore, i should see the following results: 0.004% & 0.02%
Any way to get the results? Again, i thought the caculated field would get me there....
Thanks,
Michael
Is it possible to do % in pivot tables. I thought the calculated field was a way to get around % in pivot tables... For example, if i have the following pivot table:
Inv$ Total Sell-Thru Region DC
63,347 17,421,341 XXXX XXXX
1,809,608 99,536,632 XXXXX XXXXX
My goal is to get a percentage of Inv$ of Total Sell-Thru, therefore, i should see the following results: 0.004% & 0.02%
Any way to get the results? Again, i thought the caculated field would get me there....
Thanks,
Michael