Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
|
|||
|
|||
Quote:
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
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - Editing the data source shared by multiple pivot ta | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |