Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables and Fiscal Year
When grouping dates by quarters in a pivot table, is there any way to modify
which months are considered Q1, Q2, etc? I'd like Q1 to reflect dates from July-September rather than Jan-March. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables and Fiscal Year
I use a helper column in the data table (before the pivottable is built) to show
the year and quarter. I use this formula to show the fiscal year and quarter: ="FY"&YEAR(A1)-(MONTH(A1)<#)&"-Q"&INT(1+MOD(MONTH(A1)-#,12)/3) Where # represents the first month of the fiscal year. So if the fiscal year starts on July 1st, then I'd use: ="FY"&YEAR(A1)-(MONTH(A1)<7)&"-Q"&INT(1+MOD(MONTH(A1)-7,12)/3) RE Miller wrote: When grouping dates by quarters in a pivot table, is there any way to modify which months are considered Q1, Q2, etc? I'd like Q1 to reflect dates from July-September rather than Jan-March. Is this possible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get pivot table to order months by our fiscal year? | New Users to Excel | |||
Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
Pivot Table: Change dates to fiscal year | Excel Worksheet Functions | |||
Pivot Table: Change dates to fiscal year | Excel Discussion (Misc queries) | |||
Birthdate as fiscal year | Excel Discussion (Misc queries) |