Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: Change dates to fiscal year
How do I change the dates in a pivot table from showing up according
to calandar year and make them show up fiscal year? My fiscal year begins April 1st. I am wanting to choose 2006 as my year and then have the months begin in April of 06' and end through March of 07'. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: Change dates to fiscal year
Create a helper column in your source data: =IF(month(A1)<5,"Fiscal yr
2006","Fiscal year 2007") (assuming date is in column A of your source table) and then reconstruct your pivot table taking into account the new helper column. Insert the fiscal year denotation where necessary. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "denhamlee" wrote: How do I change the dates in a pivot table from showing up according to calandar year and make them show up fiscal year? My fiscal year begins April 1st. I am wanting to choose 2006 as my year and then have the months begin in April of 06' and end through March of 07'. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining fiscal month for pivot table | Excel Discussion (Misc queries) | |||
Birthdate as fiscal year | Excel Discussion (Misc queries) | |||
Lookup dates, fiscal period table | Excel Worksheet Functions | |||
Fiscal Year Calculation | Excel Worksheet Functions | |||
Pivot Table Fiscal Years | Excel Discussion (Misc queries) |