Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Fiscal Years
My pivot table groups data by calendar year. Can I make it group data by my
fiscal year (Dec - Nov) instead? I want to end up with a column for each of my 3 fiscal years rather than 3 calendar years. Many thanks -- Sadie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Fiscal Years
A simple way to add a fiscal year column in the database to convert the
calendar year to Fiscal year. if you have a date field you can use this formula to convert calendar to fiscal year "=IF(MONTH(E4)=12,YEAR(E4)+1,YEAR(E4))" where E4 should be the calendar date field. This fiscal year column could be added on the pivot table "Sadie" wrote: My pivot table groups data by calendar year. Can I make it group data by my fiscal year (Dec - Nov) instead? I want to end up with a column for each of my 3 fiscal years rather than 3 calendar years. Many thanks -- Sadie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
pivot table, vba or ??? | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |