I have a pivot table with a calculated field for % of Total. I want to take that calculated field value and multiply it by an outside value to create another calculated field within my pivot table.
For instance:
Values
Analyst Companies % of Total
Debbi 11 12%
Sue 34 38%
George 12 13%
John 19 21%
Stan 14 16%
Total 90 100%
% of Total is a calculated field within the Pivot Table. I want to create another Calculated field which takes the !2% and mulitplies it by 414. I would then have this result in my table.
VOTES
Debbi 12% 51
Sue 38% 156
George 13% 55
John 21% 87
Stan 16% 64
Grand 100% 414
My preference is not to calculate this outside of the pivot table because I have to update it periodically and post it. any ideas?
For instance:
Values
Analyst Companies % of Total
Debbi 11 12%
Sue 34 38%
George 12 13%
John 19 21%
Stan 14 16%
Total 90 100%
% of Total is a calculated field within the Pivot Table. I want to create another Calculated field which takes the !2% and mulitplies it by 414. I would then have this result in my table.
VOTES
Debbi 12% 51
Sue 38% 156
George 13% 55
John 21% 87
Stan 16% 64
Grand 100% 414
My preference is not to calculate this outside of the pivot table because I have to update it periodically and post it. any ideas?
