| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I set a filter on the source data for a pivot table
I want to exclude certain records from a pivot table... i.e.,
Buy/Sell Quantity B 5,000,000.00 S 5,000,000.00 B 1,000,000.00 B 10,000,000.00 S 7,000,000.00 B 500,000,000.00 S 200,000,000.00 Only inlcude "B" records. Can a pivot table be set up to filter? Thanks ChrisP |
|
#2
|
|||
|
|||
|
You could add the Buy/Sell field to the page area of the pivot table,
and select B from the dropdown list there. ChrisP wrote: I want to exclude certain records from a pivot table... i.e., Buy/Sell Quantity B 5,000,000.00 S 5,000,000.00 B 1,000,000.00 B 10,000,000.00 S 7,000,000.00 B 500,000,000.00 S 200,000,000.00 Only inlcude "B" records. Can a pivot table be set up to filter? Thanks ChrisP -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
Thx for the response... this works fine and is more efficient... rgds
"Debra Dalgleish" wrote: You could add the Buy/Sell field to the page area of the pivot table, and select B from the dropdown list there. ChrisP wrote: I want to exclude certain records from a pivot table... i.e., Buy/Sell Quantity B 5,000,000.00 S 5,000,000.00 B 1,000,000.00 B 10,000,000.00 S 7,000,000.00 B 500,000,000.00 S 200,000,000.00 Only inlcude "B" records. Can a pivot table be set up to filter? Thanks ChrisP -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get pivot data formula - is it the thing to do | Excel Worksheet Functions | |||
| Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
| Data Source Name Not Found | Excel Worksheet Functions | |||
| Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
