LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 45
Default Page Filters

Pivots allow you to add criteria at the page level, but when you drop it down
you can only select one thing. How can I make it so I can select multiple
variables?

Otherwise, how can I add a filter to the pivot that I can select and
deselect w/o making the specific data show on the pivot table.

i.e. I have a number of values
Unit# - Unit Use - Unit Class
123 P E
124 P R
111 P S
133 P R
122 P E
132 P E

I want to see units equal to E and R, but I don't want this column showing
on my table
--
Hile
 
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
How to copy with filters but not copy the filters in the middle? ztalove Excel Discussion (Misc queries) 0 November 1st 06 04:53 PM
Not all Filters made on Page Field Variables Update the Data ThereIs Excel Worksheet Functions 0 August 23rd 06 11:07 AM
Filters, Subtotal & Intacted Results after the filters' Removal kasiopi Excel Discussion (Misc queries) 5 February 24th 06 12:18 PM
Filters Becks Excel Discussion (Misc queries) 0 January 16th 06 11:02 AM
filters acess New Users to Excel 3 December 7th 05 07:15 AM


All times are GMT +1. The time now is 12:44 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"