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.

TIA
gls858

Pivot tables
 

Hi

Use the GetPivotData function - which will adjust to where the value is
held.
For more information take a look at
http://www.contextures.com/xlPivot06.html
--
Regards
Roger Govier

gls858 wrote:
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.

TIA
gls858

Pivot tables
 

On 5/18/2010 15:10, Roger Govier wrote:
Hi

Use the GetPivotData function - which will adjust to where the value is
held.
For more information take a look at
http://www.contextures.com/xlPivot06.html
--
Regards
Roger Govier

gls858 wrote:
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.

TIA
gls858


Thanks for the pointer. I check it out and see if I can make it work.

gls858

using a simply vlookup, you can fetch the totals data for the current month

i have attached spreadsheet. please refer it

VLOOKUP("GRAND TOTAL,RANGE,6,0)

pivot always generates as GRAND TOTAL
RANGE: DEFINE A RANGE FROM JAN TO DEC
value 6, current is may, if june change to 7, or automate it by today function, going further in advance.


all the best