Sort in Pivot (Excel 2010)

[Bandini]

Hi!

I hva a Pivot where I have first row filter sellers. the next row filter is customers. I can now see the sellers customers. Some sellers have only one customer and they are not interesting for me. I only want to see sellers with more than one customer. Is this possible?

B

[JosephP]

not within the pivot table-unless you use powerpivot or only have one entry in the source data per seller/customer combination
you can add formulas adjacent to the pivot to count the customers and then filter that column to achieve similar behavior but that will not automatically expand/contract with the pivot table

[Bandini]

Ok, could you just give me an idea of how the formula will be?

M

[JosephP]

using 2010 you can set the seller field to repeat for each customer and then assuming that the seller field starts in B5 and extends to B100 use
a5: =COUNTIF($B$5:$B$100,B5)>1
and copy down to a100 then autofilter that column for TRUE values