Pivot table

B

bay

Hi,
I am working on a pivot table that on the headres has months (1-12) and
years (2000-2005). How can I display data up to february 2005?

I can either hide all months (from 1-12) for any years or none at all. Is
this normal? If use the normal column hide function for individiual months
than they are hidden but still they are calculated tin the totals. I want
them to be excluded from the total as hide from pivot table month does, bus
still i cannot hide individual months.

Any help welcome.
 

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

Top