Hi,
I have some data that I'm creating a pivot against. Two columns of it I want to sum, and I can do this fine. Then, I want a third value, which takes the first column and divides it by the second.
Example Data:
Item---Price1---Price2
A-------10---------20
A-------20---------40
B-------5-----------15
B-------10----------30
Example Pivot:
Item-----Sum of Price1------Sum of Price2------%Difference
A------------30------------------------60---------------------50%
B------------15------------------------45---------------------33.3%
Bookmarks