software

Dear All,

I have a Pivot Table where in the quot;Pagequot; section I have a Field called
Postcodes.

Is there any way for me to filter these postcodes so I can select a
certain range without having to create a seperate Pivot with a subset
of my main data?

eg ... (for Australia Postcodes) I want to sum up all my transactions
per companythat fall between postcodes 2000 and 2050. I don't want to
select all the postcodes listed, and I don't want to have to do one
postcode at a time.

Thanks in Advance...andymHi Andy
Unfortunately PT does not allow grouping of Page fields directly.
Temporarily drag your Postcode field from Page to Row.
Right click on field gt;Groupgt; start 2000 end 2050 by 50
Drag field back to Page area
Select Group 2000-2050

--
Regards

Roger Goviergt; wrote in message oups.com...
gt; Dear All,
gt;
gt; I have a Pivot Table where in the quot;Pagequot; section I have a Field called
gt; Postcodes.
gt;
gt; Is there any way for me to filter these postcodes so I can select a
gt; certain range without having to create a seperate Pivot with a subset
gt; of my main data?
gt;
gt; eg ... (for Australia Postcodes) I want to sum up all my transactions
gt; per companythat fall between postcodes 2000 and 2050. I don't want to
gt; select all the postcodes listed, and I don't want to have to do one
gt; postcode at a time.
gt;
gt; Thanks in Advance...
gt;
gt;
gt; andym
gt;
Thanks Roger,

I'll give that a go....Regards,

andy...