Pivottable:adding grand totals

How do you add together grand totals, also would there be a way to
subtract a "grand total" from another number on another worksheet?

You can use the GetPivotData function to return data from a pivot table.
There's information here:

http://www.contextures.com/xlPivot06.html

and in Excel's Help.

arthursdomain@gmail.com wrote:
> How do you add together grand totals, also would there be a way to
> subtract a "grand total" from another number on another worksheet?
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I actually went to that site before, but I didnt think it was relevant.
However, after looking at it after your suggested it, it worked
perfectly. Thank you.

I ran into another problem, which is not really related to the previous
problem/question.
Is there a way to filter multiple dates or a date range in pivot
tables? Theres the drop down
box which they have, however you can only pick one or all (office xp).
Is there a way to pick more than one day or a range of dates that you
can input and it will filter out the information.

Also do you need to have the pivot table showing the information to
have it give a result or is there a 'formula' that you can type in to
create your own filters? Like if currently the table is filtering
Males/Brown Hair and it shows 3 but In another worksheet or cell i can
put =GETPIVOTDATA("Female","Black Hair")? Even though the pivot table
currently only is showing males/brown hair?

You can double-click on field button in the page area, and select the
items you want to hide or show.

For the GetPivotData formula, the data must be visible in the pivot
table, for the formula to return the data.

Z wrote:
> I actually went to that site before, but I didnt think it was relevant.
> However, after looking at it after your suggested it, it worked
> perfectly. Thank you.
>
> I ran into another problem, which is not really related to the previous
> problem/question.
> Is there a way to filter multiple dates or a date range in pivot
> tables? Theres the drop down
> box which they have, however you can only pick one or all (office xp).
> Is there a way to pick more than one day or a range of dates that you
> can input and it will filter out the information.
>
> Also do you need to have the pivot table showing the information to
> have it give a result or is there a 'formula' that you can type in to
> create your own filters? Like if currently the table is filtering
> Males/Brown Hair and it shows 3 but In another worksheet or cell i can
> put =GETPIVOTDATA("Female","Black Hair")? Even though the pivot table
> currently only is showing males/brown hair?
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html