Show 2 totals in Pivot Table

Topic

New Reply

Hello. (Access 2007)

I’m constructing a pivot table based on a simple staff table, with salary, office, department, etc.

I’m showing the minimum salaries within each office. How can I also show the maximum salaries within the same report?

Thanks, Andy.

Reply | Quote

Replies

If You Right Click on the Salary Field in the Pivot Table do you not get offered AutoCalc as an option and Max should be in that.

Reply | Quote

Hi, and thanks. When I did that the first time it showed as a second total within the same salary column. I just did it again and it initially
displayed a separate salary column – so I had one for Min and one for Max (as required).
I have a row area of Office; if I hide the details for this the max again becomes a separate column. Perhaps this is the way it is supposed to behave?
Andy.

Reply | Quote