Top 10 And Bottom 10 Items in the Same, One PivotTable Excel 2007

[Myproblem]

I need to show on PivotTable Excel 2007 both Top 10 And Bottom 10 Items, in the same, only one PivotTable
I was wondering is it possible to show it in one PivotTable.

I know how to show it just for Top 10 or Bottom 10, but I need to show both Top 10 And Bottom 10 Items.

Maybe I was missing something and It is maybe possible, but I do not know how.

Any idea, tips - maybe some VBA?

 

[T-to22]

Hi there,

I encountered the same problem some time ago.

The easiest way to get both top 10 and bottom 10 (not using vba) was for me to have 2 pivot tables right underneath eachother.
The top pivot table contained the top 10 and the bottom pivot table the bottom 10.

Somebody probably has some VBA code for this but having 2 pivot tables already did the job for me.

Grts,

Tito

 

[Myproblem]

great idea, but I am not only person which use these report. other user do not know how to make just one create pivot table and do filtering

my guess VBA would be the great solution

 

[T-to22]

Hi,

Wouldn't it work if you just created the 2 pivot table with the correct filters and not delete them afterwards?
So you would just always have the 2 pivot tables in one sheet that are always there. This way the other users won't have to go and create their own pivot tables everytime.

grts,

Tito

 

[vikingX]

Did anyone ever find a good solution for this issue?

 

[Myproblem]

I did not.

 

[Danny3]

Try finding at which values the top 10 and bottom 10 lies, then filter on NOT between those values. Example: Top 10 revenue mostly starts at 750 000 and bottom 10 mostly starts at -110 000. Then filter on 'not between' 750 000 and -110 000