LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Quarterly Statements in Pivot Tables

Sorry this took me soooo long to thank you.
But THANK YOU!!!
I like the variety of your ideas!

"ShaneDevenshire" wrote:

Hi,

There is nothing built-in to do this.

If your quarters are on the correct break but a different quarter you can
just type over the names of the quarter but spell is slightly different. For
example change Qtr1 to Q2 and so on.

Or

You can fake it. Create a dummy column in the source data. For example, if
A2:A100 contained your dates, then in the dummy column enter a formula like
=EDATE(A2,x)
X should be a positive or negative number indicating how many months offset
from the real month, your month should be. -1 means one month back, 1 is one
month forward.

Add this field to the pivot table and group on it.


--
Thanks,
Shane Devenshire


"TB in DC" wrote:

Is there someway to change the Quarterly Statement in the Pivot Table
Groupings so that my Quarters start in another month rather than January?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 08:05 PM
Pivot Table - Quarterly report SA Excel Discussion (Misc queries) 1 November 9th 07 06:43 PM
Pivot tables, IF statements, vlookups? dannyrblock Excel Worksheet Functions 2 September 20th 07 09:40 PM
look up tables and IF statements Rick New Users to Excel 9 May 29th 06 02:10 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 01:34 AM


All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"