Pivot Table Show Pages On Same WorkSheet

D

dprotaso

For a pivot report, with the pages setup to each year, how can I
customize show pages command to append additional new pivot reports to
the current worksheet instead of creating new ones?

Additionally is there anyway to lay out each report on a different
page when doing this? This would save me time from having to insert
page breaks.

thanks
 
D

Debra Dalgleish

There are no settings you can change to adjust the way that the Show
Pages command works.
 
D

dprotaso

Thanks, for the reply, I have one more question.

For a pivot table if I group a date field in a column by month is
there anyway to change the ordering? By default it starts with Jan-
Dec, but I'd prefer if it starts with May-Apr (by fiscal year)

Thanks,
dave
 
D

Debra Dalgleish

You can't change the months that are grouped in a year. You could create
another field in your source data, and calculate the fiscal year and
month. Then add that field to the pivot table, instead of grouping the
dates.

Thanks, for the reply, I have one more question.

For a pivot table if I group a date field in a column by month is
there anyway to change the ordering? By default it starts with Jan-
Dec, but I'd prefer if it starts with May-Apr (by fiscal year)

Thanks,
dave
Click to expand...
 
R

Roger Govier

Hi

The way I get around this is to create a new Custom List.
Tools>Options>Custom Lists> type your List May, Jun ...... Apr in a
column in the white pane and choose Add.
Double click on your date field>Advanced>Sort>Ascending

--
Regards

Roger Govier


Thanks, for the reply, I have one more question.

For a pivot table if I group a date field in a column by month is
there anyway to change the ordering? By default it starts with Jan-
Dec, but I'd prefer if it starts with May-Apr (by fiscal year)

Thanks,
dave
Click to expand...
 
D

Debra Dalgleish

You could, or you could manually rearrange the dates, but they'd be in
the wrong fiscal year, if you just group the dates by year and month.
 
D

dprotaso

I've already created a fiscal year field so it's a matter of sorting
the months.

I'll check out the custom list.

thanks,
dave
 
Top