getting updated info from pivot tables

M

marksuza

Hi everyone,

I created a pivot table with months as column and sum of clients an
sum of members as rows. I take the last month and Grand total number
to another table I use for reporting. Is there a formula that I ca
use to tell the table to get the last month (grand total - 1) and gran
total numbers so when I update the pivot I dont have to change the othe
table all the time.

Thanks for the help,

Marco
 
Top