I have a pivot table in EXCEL. One column contains $ and the next % of those dollars to the total.
Header Amount % of Total Need calculation here
Row 1 $500 40% 40%
Row 2 $500 40% 80%
Row 3 $250 20% 100%
Total $1,250 100%
This data is in a pivot table. I would like to add a calulation in the pivot that would add each row's % of total (see need calculation here) header.