PivotTable "show data value as" question


Fred Chow

Hi all,

I have a problem about using Pivot Table in Excel 2003:

In a pivot table I have a date field, grouped by year and month, as the row
field. The data field of the table is anything that can be summed.

Now when I tried to display the data field value as "Difference from
previous month", I found that January of each year is always blank, ideally
the data value in January should be display as the difference between the
actual January value minus December value of the last year. Any tricks to
show them? Thanks a lot.

Frederick Chow
Hong Kong.

Debra Dalgleish

If you group the dates by year and month, the Difference From will start
over at the beginning of each year. There's no setting you can change to
make that behave differently.

You could add a field to the source data, and calculate the year and
month. For example, if the date is in column A:

Add that field to the pivot table, instead of the grouped date, and the
Difference From calculation will flow from one year to the next.

Fred Chow

What a shame that it is "built-in" bug...

Anyway thanks a lot.

Frederick Chow
Hong Kong.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question