I query a database to get a 31 by 12 matrix of months and days for a total number of values for a year and return the data to a pivot table. Let's say for example the company sells widgets and my boss wants a report that shows the number of widgets by day and Month that are sold for the whole year. A pivot table is great for this because I put the months on the columns and the days of the months on the rows.

He also wants to know by month or column what is the minumum , maximum, average and total number of sales by month. I have been able to do this by using two queries to the database and using two pivot tables. It seems though that the one pivot table could do this but I just can't figure out how to calculate the aggregate values by month and have them only reported at the bottom of the pivot table just like the grand totals are. What concept am I missing?? I will express my thanks to any help in advance...