Hi All-
Quick question about pivot table groupings. I have an exhibit that shows data by month. At the bottom of the table I would like not only the grand total, but also totals by year and/or quarter.
Essentially I want to be able to do a typical pivot table grouping, but for that grouping to only be at the bottom, and not in the actual data rows.
Quick question about pivot table groupings. I have an exhibit that shows data by month. At the bottom of the table I would like not only the grand total, but also totals by year and/or quarter.
Essentially I want to be able to do a typical pivot table grouping, but for that grouping to only be at the bottom, and not in the actual data rows.