Hello,
On the attached worksheet I have everything set up how I would like in a pivot table, however I am wondering where or what the setting should be for subtotals of the Profit Margin category?
The sheet currently auto-sum's the column, which i'm sure is default. How do I change it so that Cells I19, I34, and I36 are not added up, but are actually the quotient of the 2 cells before?
This is exactly what i'm looking to accomplish:
I9=(H9/G9)
I34=(H34/G34)
I36=(H36/G36)
Thanks,
Adam
Bookmarks