I have a pivot table with a calculated field of % of Total.
I now want to take that % of total value and multiply it by a random number for % of Total values in the table.
Debbi % of Total 30%
John % of Total 30%
Sue % of Total 40%
% of Total is a calculated field, so it's not available in the Formulas field box.
I want to take 30% and multipley by 414 and obtain 124.2, 124.2 and 165.6 respectively within the pivot table. How do I do this. THANK you.
I now want to take that % of total value and multiply it by a random number for % of Total values in the table.
Debbi % of Total 30%
John % of Total 30%
Sue % of Total 40%
% of Total is a calculated field, so it's not available in the Formulas field box.
I want to take 30% and multipley by 414 and obtain 124.2, 124.2 and 165.6 respectively within the pivot table. How do I do this. THANK you.
