excel - Filter PivotTable on Top 10 records -


i have spreadsheet columns var1, var2and var3 aggregated (total) column @ end. need pivottable, based on top 10 highest totals.

is possible?

when try filter table, can see individual records filter criteria, not usual excel filtering options.

yes, facility available within pivottable filtering rows (the funnel next var1), value filters, top 10..., top 10 items sum of total:

so30951042 example


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -

jdbc - Not able to establish database connection in eclipse -