excel - Filter PivotTable on Top 10 records -
i have spreadsheet columns var1
, var2
and 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
:
Comments
Post a Comment