Pivot table field

S

SD

Hi,
I have data in a RDBMS table as storeid,month,product, sales,returns,
quarter to date, year to date . I want to calculate a report so that
the months should show up as n,n-12,n-24 etc so that I can compare the
same data year over year without selecting the month from the drop
down and checking/unchecking of months.

Else
What is an alternate design of the table that renders itself to pivot
if I want to capture the above metrics

Thanks

Sd
 
Top