LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Filtering Pivot Table Data

Dear All,

I have a Pivot Table where in the "Page" 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...


andym

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Pivot table Data area show/hide behavior Peter Ross Excel Discussion (Misc queries) 0 January 20th 06 10:37 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"