I am trying to find out the Rate of Sales for each store
this is generally calculated by Value Sales/Number of Weeks Sold
which works in a normal sheet.
However how I do this in a pivot table baffles me as I cannot get it to produce the correct answer
I have my file here [http://www.box.com/s/u9ijzx7j11ra0tstr6jg] for any Pivot gurus to look at.
along with what are the correct answers.
There must be something I am doing wrong
Can anyone suggeest what?
Martin
this is generally calculated by Value Sales/Number of Weeks Sold
which works in a normal sheet.
However how I do this in a pivot table baffles me as I cannot get it to produce the correct answer
I have my file here [http://www.box.com/s/u9ijzx7j11ra0tstr6jg] for any Pivot gurus to look at.
along with what are the correct answers.
There must be something I am doing wrong
Can anyone suggeest what?
Martin
Last edited: