B
Blue Fish
Hello:
I have a case that the pivot table's source data from the column that
was in month. I have try to use this data in pivot table it show the
format was not that I expected. May I know how can I correct it?
Date Month Units
02-Jan-2008 January-2008 234
08-Jun-2008 June-2008 5
21-Apr-2008 April-2008 235
16-Aug-2008 August-2008 34
26-Aug-2008 August-2008 6
26-Jul-2008 July-2008 6
29-Apr-2008 April-2008 34
13-Apr-2008 April-2008 6
I expect the pivot table result like this. How can I do?
Row Labels Sum of Units
April-2008 275
August-2008 40
January-2008 234
July-2008 6
June-2008 5
Grand Total 560
Thanks!
I have a case that the pivot table's source data from the column that
was in month. I have try to use this data in pivot table it show the
format was not that I expected. May I know how can I correct it?
Date Month Units
02-Jan-2008 January-2008 234
08-Jun-2008 June-2008 5
21-Apr-2008 April-2008 235
16-Aug-2008 August-2008 34
26-Aug-2008 August-2008 6
26-Jul-2008 July-2008 6
29-Apr-2008 April-2008 34
13-Apr-2008 April-2008 6
I expect the pivot table result like this. How can I do?
Row Labels Sum of Units
April-2008 275
August-2008 40
January-2008 234
July-2008 6
June-2008 5
Grand Total 560
Thanks!