2 Columns with same data expressed differently

[DeaninGA]

How do you add 2 columns of the same data in a pivot table?

• The First is the Sum
• The Second is Grand total divided by the Sum expressed in %

Thank you in advance

Dean

 

[sandy666]

try
add the same column twice then
first:

second