filter on pivot table

[jigio]

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]

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

[jigio]

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]

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

[jigio]

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
>
>