Pivot Table - Group Headings

D

Dan Reynolds

Greetings

I have a pivot table with dates as the headings, but the dates are grouped
into month and year. My data is financial year july 03-june 04 and I would
like to select "Show items with no data" from the month field, but this
displays january to June 03 which I don't want to see because it is not in
the 03/04 year. How can I display all months in the 03/04 financial year
only (and not display jan-jun 03 or jul-dec 04)

thanks in advance.

Dan
 

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