 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / April 2007Pivot 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 There are no settings you can change to adjust the way that the Show Pages command works. > 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 [quoted text clipped - 3 lines] > page when doing this? This would save me time from having to insert > page breaks.  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html 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 > There are no settings you can change to adjust the way that the Show > Pages command works. [quoted text clipped - 11 lines] > Debra Dalgleish > Contextureshttp://www.contextures.com/tiptech.html 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. > [quoted text clipped - 21 lines] >>Debra Dalgleish >>Contextureshttp://www.contextures.com/tiptech.html SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html 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 SignatureRegards Roger Govier > Thanks, for the reply, I have one more question. > [quoted text clipped - 21 lines] >> Debra Dalgleish >> Contextureshttp://www.contextures.com/tiptech.html 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. > 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 SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html 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 > 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. [quoted text clipped - 9 lines] > Debra Dalgleish > Contextureshttp://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.