Pivot Table - Top 10 Based on Specific Column

[Sandi]

Hi there -
My database is setup as follows as shown below. I am trying to FILTER the results to show TOP X based on TYPE, PROD2...not total sum of PROD2.

Name....Type....Base ADV
ABC......Prod 1....50
ABC......Prod 2....90
DEF......Prod 3.....20
GHI......Prod 1.....50
GHI......Prod 2.....70
JKL.......Prod 2.....95
MNO.....Prod 1.....100

When i filter TOP X, it is based on SUM OF TYPE and I get the following view:

Name....Type....Base ADV
ABC......Prod 1....50
...........Prod 2....90
GHI......Prod 1.....50
...........Prod 2.....70
MNO.....Prod 1....100
JKL.......Prod 2.....95
DEF......Prod 3.....20

I would like the pivot to return the following view:

Name....Type....Base ADV
ABC......Prod 1.....50
...........Prod 2....90
GHI......Prod 1.....50
...........Prod 2.....70
JKL.......Prod 2.....95

Essentially I want all the data returned for only the TOP "Prod 2".

Hopefully I am explaining myself correct and am hoping Excel Pivot can do this!

Thanks!