Pivot Table Show Pages On Same WorkSheet
 

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

Pivot Table Show Pages On Same WorkSheet
 

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

wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Show Pages On Same WorkSheet
 

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

On Apr 20, 7:43 pm, Debra Dalgleish wrote:
There are no settings you can change to adjust the way that the Show
Pages command works.

wrote:
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.

--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html

Pivot Table Show Pages On Same WorkSheet
 

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.

wrote:
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

On Apr 20, 7:43 pm, Debra Dalgleish wrote:

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

wrote:

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.

--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Show Pages On Same WorkSheet
 

Hi

The way I get around this is to create a new Custom List.
ToolsOptionsCustom Lists type your List May, Jun ...... Apr in a
column in the white pane and choose Add.
Double click on your date fieldAdvancedSortAscending

--
Regards

Roger Govier


wrote in message
ups.com...
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

On Apr 20, 7:43 pm, Debra Dalgleish wrote:
There are no settings you can change to adjust the way that the Show
Pages command works.

wrote:
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.

--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html

Pivot Table Show Pages On Same WorkSheet
 

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.

Roger Govier wrote:
Hi

The way I get around this is to create a new Custom List.
ToolsOptionsCustom Lists type your List May, Jun ...... Apr in a
column in the white pane and choose Add.
Double click on your date fieldAdvancedSortAscending



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot Table Show Pages On Same WorkSheet
 

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

On Apr 22, 9:04 am, Debra Dalgleish wrote:
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.

Roger Govier wrote:
Hi

The way I get around this is to create a new Custom List.
ToolsOptionsCustom Lists type your List May, Jun ...... Apr in a
column in the white pane and choose Add.
Double click on your date fieldAdvancedSortAscending

--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html