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 turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

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,963
Messages
5,575,265
Members
412,653
Latest member
JyothiGrace
Top