Pivottable:adding grand totals

A

arthursdomain

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

Z

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?
 
D

Debra Dalgleish

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.
 
Top