A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pivot tables



 
 
Thread Tools Display Modes
  #1  
Old May 18th, 2010, 08:22 PM posted to microsoft.public.excel.newusers
gls858
external usenet poster
 
Posts: 473
Default 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  
Old May 18th, 2010, 09:10 PM posted to microsoft.public.excel.newusers
Roger Govier[_8_]
external usenet poster
 
Posts: 338
Default 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  
Old May 18th, 2010, 09:43 PM posted to microsoft.public.excel.newusers
gls858
external usenet poster
 
Posts: 473
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:08 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.