Calculating the Difference between the same Sumof Field

[areadman]

Hi,

I have a Pivot Table created from a query as follows.

Query:
[Net Sales]
Week No: Format([Sales Date],"ww")
New Week No: Right("0" & [Week No],2)
[Sales Date]

Having created a Pivot Table from the above query, it look like the image attached. Since the SumOfNet Sales is the same field, how do I calculate the difference between the 2 for each year. Ie. for say Week No 15, to calculate the difference between Net Sales of 2011 to Net Sales 2010.

Thank you in advance for your help.

Regards



Alex

[aytee111]

I don't know anything about pivot tables, but shouldn't your week no be:

Format(SalesDate,"yyyy") & Format([Sales Date],"ww")