slicer to do top 10 value filter

[koi]

Hi All,

I'm using excel 2013 and want to ask if we can use slicer to show top 10 or bottom 10 value filtered.

thanks

 

[Debraj]

OK 2013.. then its good to use Power Pivot.. it has much more capabilities than Pivot..

Check here..
http://www.powerpivotpro.com/2012/07/dynamic-topn-reports-via-slicers-part-2/

 

[koi]

Hi Debraj,

thanks for the answer and i've seen that topic before only not really into powerpivot so i posted question here to search for another option, one question though.. if i setup the slicer using power pivot, can it still working for people using excel 2010 and they dont have power pivot installed?

-- just download file in above link and try to do the slicer and it wont work since my powerpivot data model and his is different, so i think powerpivot must be use only if you have same version installed --

then i think must add another helper column and put top 1 - top 10 then pick that column using slicer

thanks again