CRshield
asked on
pivot table with a fiscal year cycle
I want to make a pivot table with 4 quarters but the 1st quarter starts Oct 1 not Jan 1st
how can I make the 1st quarter start in Oct
I have date format of mm/dd/yy and yyyymm
how can I make the 1st quarter start in Oct
I have date format of mm/dd/yy and yyyymm
ASKER
this might work
what about grouping months together and then labeling it? Saw it in a video lesson last night.
but I am not sure I can group more that 1 3 month period, can I?
what about grouping months together and then labeling it? Saw it in a video lesson last night.
but I am not sure I can group more that 1 3 month period, can I?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
...Terry
PivotQ.xlsx