Windows XP, Excel 2007
Please can anyone tell if it is possible to group months in the columns in a pivot into quarters or years, and return the last value of a period when grouping.
I have a pivot with several items under the rows field, and for most of these items it is appropriate to sum...