Getting only top 10 values from an Pivot table

0
votes

I have created some pivot tables which shows sales of PC from different brands for multiple years. for example 2013 PC sales of dell,HP,Apple etc...

Now I want to compare these sales but I just want to compare top 10 results...I am trying to create a table which will show only the top ten values from the pivot table. I dont want to filter the pivot table to top 10 values.

Thanks and Regards

1
excelpivotexcel-formulapivot-tablepowerpivot
Why don't you want to filter the pivot table? Is to possible to sort the values from largest to smallest? – Andre Silva

1 Answers

0
votes

If you have to create your output as a table without filtering the pivot table, you can use cube functions. Create a cubeset that is all PC brands and order them by PC Sales. Create cubrankedmember functions for positions 1 through 10. Then write a cubevalue formula next to each cuberankedmember to retrieve the associated value. If you want to post a little more about your data model, I could write more specific cube function formulas.