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:
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
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:
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