Pivot Table problem

  • Thread starter Thread starter Rob Botterill
  • Start date Start date
R

Rob Botterill

Hi

My organisation has recently changed financial year from Jan to Dec to April
to March. All of our Pivot tables ran from tables held in sql and were
simply made up from two fields that were Year & Period (2001, 01), where 01
was Jan is now April. We have converted all of the historical records so
that 01 now = April. However, we still have some users that require their
Pivot tables to see Jan to Dec by Year. Is there anyway I can set the Pivot
table to report the columns headings so that they start 2000 10 to 2001 009
and so that the grand totals are calculated for these periods?

Does this make sense..!?

Rob
 
To achieve this, you'd need another column in the output, that indicated
the actual month of the data. For example, all the records from Jan 2001
would have the date 1/1/01.

Users could add that field to the pivot table, and hide dates they don't
want.
 
Back
Top