Calculating percentage from pivot table Grandtotals column

jocote46

New Member
Joined
May 11, 2009
Messages
43
Hello VBA experts,

I have a pivotTable source that have a list of Products Id's . Each Product Id have a GrandTotal. my objective is to look at the Product ID on the pivot table and calculate the percentage. See sample picture below:
1603393294592.png

Keep in mind that Product ID could be in a different Row (Column A) since one Day could have more transactions than another. let me know if you have any questions. thank you in advance for your help.

Walt
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

jocote46

New Member
Joined
May 11, 2009
Messages
43
Just want to let you know that I found an alternate solution. in the pivot table you can add another column but instead of Sum fuction on the Total column, you can show the values as a % of the column total. This has been solved.
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,481
Members
412,596
Latest member
nickthebizz
Top