Pivottable last 6 months

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I have a pivot table with customers down the left side
(rows - (Name)) and the dates along the top (columns
(date)) with sales as the data (Sum of Sales). All of it
is linked to an Access db query so the info is constantly
updated.

I want to show the change in sales to each customer over
a 6 month period current year to previous year. I
thought about creating more queries in Access so that
only the last 6 months shows and then the same period of
the previous year and importing them as 2 seperate fields
(current_sales, previous_yr_sales) fields then doing a
calculated field ([current_sales]-[previous_yr_sales]).
Is there an easier way to do it in the pivot table?

Thanks
 
You can use pivot chart to compute the change or % change.

Go to field setting and select Option
 
Back
Top