B
Becksicle
Hello,
I have a pivot table that is basically saying how much business a sales
person has closed per quarter over an 18 month period. The data is coming
from an automatic export from our sales database, so I am unable to change my
source data. See example of pivot table:
A B
Year Qtr Columns C - G then have sales people's names with Sum of Amount
2006 Q3
2006 Q4
2007 Q1
2007 Q2
2007 Q3
2007 Q4
However, our FY runs from July to June. So actually 2006 Q3, is 06/07 Q1.
A B
Year Qtr Columns C - G then have sales people's names with Sum of Amount
0607 Q1
0607 Q2
0607 Q3
0607 Q4
0708 Q1
0708 Q2
Is it possible to customise the date grouping in a pivot table so that I can
specify July as my start of year and have pivot tables summarising by FY
rather than CY?
Thanks Rebecca
I have a pivot table that is basically saying how much business a sales
person has closed per quarter over an 18 month period. The data is coming
from an automatic export from our sales database, so I am unable to change my
source data. See example of pivot table:
A B
Year Qtr Columns C - G then have sales people's names with Sum of Amount
2006 Q3
2006 Q4
2007 Q1
2007 Q2
2007 Q3
2007 Q4
However, our FY runs from July to June. So actually 2006 Q3, is 06/07 Q1.
A B
Year Qtr Columns C - G then have sales people's names with Sum of Amount
0607 Q1
0607 Q2
0607 Q3
0607 Q4
0708 Q1
0708 Q2
Is it possible to customise the date grouping in a pivot table so that I can
specify July as my start of year and have pivot tables summarising by FY
rather than CY?
Thanks Rebecca