How to club two "Page" values in a pivot table ?

[sorabh]

hi
guyz i have a pivot table which has say.. ITEMS in Row header
and NAMES in Columns ie its like this...

--------- Pencil----- Rubber-----Sharpner
hank------4-----------6--------------7-----
terry------3-----------3--------------5-----
tom -------5-----------2--------------1----
sirus------3------------5--------------7----

This data is for January,February , March and so on.....
so in the PAGE option of the Pivot Table i have months
from which i can chose for any SINGLE month..
but say i want this data for two months of jan and feb
ie jan + feb
how can i do it...

regard

 

[Guest]

Here is a quick and dirty way:

First drag your page field down to the left to be your first row header field.

Then select the periods you want to add together, select Group from the pivot table menu. This creates a new field with your grouped periods called Group1 (or something similar). Drag both period fields back up to the page field area, and select Group1 for your new field and All for the period field.

 

[Debra Dalgleish]

There are a couple of techniques for hiding page items here:

http://www.contextures.com/xlPivot03.html#Page