Pivot tables



I have a pivot table. The columns are month and rows are sales people.
I want to display the grand total for the current month from the pivot
table in another cell. The pivot table is based on a named range so the
grand total line may not always be in the same row. Is that even
possible? If so could someone please point me in the right direction.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question