I have a date range mm/dd/yyyy in field K2, and for the pivot table I need to be able to sort data by mm, quarter, and year (not all at the same time) in the spreadsheet I have formatting and formulas to create the columns of data:
Start Date MONTH QUARTER YEAR
3/31/2012 Mar Q1-2012 2012
3/28/2012 Mar Q1-2012 2012
1/4/2012 Jan Q1-2012 2012
for the month =k2 and the format is changed to mmm
quarter ="Q" &INT((MONTH(K2)+2)/3) & "-" & YEAR(K2)
year =k2 and then format changed to yyyy
When I select the month, quarter, and year for the pivot table it is only reporting back as the start date. I can change the formatting to show like above, but I cannot get the data results I am looking for, I am trying to get one report back for Jan, one for Feb etc...
Instead it comes over as:
Row Labels
Jan
Feb
Feb
Feb
Mar
Mar
Mar
Mar
Mar
Apr
Apr
May
May
May
Bookmarks