filter on pivot table
 

i am trying to display on my pivot tables orders that contains product A and
product B combined in on esingle order, but what i keep getting is a list
with all the orders containing product A and/or product B. does anybody know
how to filter the orders that contain only both products, viceversa filter
out the one containing only product A or product B?
thank you so much

Depending on how your source table is set up, this may be easier to do
in the table, using an AutoFilter, instead of in a pivot table.

jigio wrote:
i am trying to display on my pivot tables orders that contains product A and
product B combined in on esingle order, but what i keep getting is a list
with all the orders containing product A and/or product B. does anybody know
how to filter the orders that contain only both products, viceversa filter
out the one containing only product A or product B?
thank you so much



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

hi debra, i actually learned a new function in excel, but unfortunately it
doens't answer my problem (at least i couldn't solve it). here is what i have
in my table:
two columns: one with order numbers and one with product numbers.

order number product number
row1: 1111, product X
row2: 1111, product Y
row3: 2222, product X
row4: 2222, product Z
row5: 3333, product X
row6: 3333, product Y
row7: 3333, product Z

what i need is to extract only order 1111 and 3333, the only one that have
product X and product Y included in the same order number.
thanks for your help
"Debra Dalgleish" wrote:

Depending on how your source table is set up, this may be easier to do
in the table, using an AutoFilter, instead of in a pivot table.

jigio wrote:
i am trying to display on my pivot tables orders that contains product A and
product B combined in on esingle order, but what i keep getting is a list
with all the orders containing product A and/or product B. does anybody know
how to filter the orders that contain only both products, viceversa filter
out the one containing only product A or product B?
thank you so much



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Assuming your pivot table has:
order number in the row area
product number in the column area
count of product number in the data area

You could hide the remaining products
Double-click the Order Number button
Click the Advanced button
For Top 10 AutoShow, select On
Change the settings to show the Top 1
Click OK, click OK

jigio wrote:
hi debra, i actually learned a new function in excel, but unfortunately it
doens't answer my problem (at least i couldn't solve it). here is what i have
in my table:
two columns: one with order numbers and one with product numbers.

order number product number
row1: 1111, product X
row2: 1111, product Y
row3: 2222, product X
row4: 2222, product Z
row5: 3333, product X
row6: 3333, product Y
row7: 3333, product Z

what i need is to extract only order 1111 and 3333, the only one that have
product X and product Y included in the same order number.
thanks for your help
"Debra Dalgleish" wrote:


Depending on how your source table is set up, this may be easier to do
in the table, using an AutoFilter, instead of in a pivot table.

jigio wrote:

i am trying to display on my pivot tables orders that contains product A and
product B combined in on esingle order, but what i keep getting is a list
with all the orders containing product A and/or product B. does anybody know
how to filter the orders that contain only both products, viceversa filter
out the one containing only product A or product B?
thank you so much



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

debra, thank you very much! that helps a lot! greetings from europe
jigio

"Debra Dalgleish" wrote:

Assuming your pivot table has:
order number in the row area
product number in the column area
count of product number in the data area

You could hide the remaining products
Double-click the Order Number button
Click the Advanced button
For Top 10 AutoShow, select On
Change the settings to show the Top 1
Click OK, click OK

jigio wrote:
hi debra, i actually learned a new function in excel, but unfortunately it
doens't answer my problem (at least i couldn't solve it). here is what i have
in my table:
two columns: one with order numbers and one with product numbers.

order number product number
row1: 1111, product X
row2: 1111, product Y
row3: 2222, product X
row4: 2222, product Z
row5: 3333, product X
row6: 3333, product Y
row7: 3333, product Z

what i need is to extract only order 1111 and 3333, the only one that have
product X and product Y included in the same order number.
thanks for your help
"Debra Dalgleish" wrote:


Depending on how your source table is set up, this may be easier to do
in the table, using an AutoFilter, instead of in a pivot table.

jigio wrote:

i am trying to display on my pivot tables orders that contains product A and
product B combined in on esingle order, but what i keep getting is a list
with all the orders containing product A and/or product B. does anybody know
how to filter the orders that contain only both products, viceversa filter
out the one containing only product A or product B?
thank you so much



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html