If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|