Pivot View: Show 'Top 10' by field

January 17, 2011 10:34AM

Hi,

In a Pivot View (or in all views), how i can show only top 10 rows by selected measure? Example:

I have 10000 records, there are 100 differents brands, and i want to show in a same tab, one view with top 10 brands by sales, and other view with top 10 brands by units sold (it maybe differents than by sales)

Thxs in advance

WKeith · July 3, 2012 10:58AM

I think that if you use a combination of Rank and Subset, you can find the top ten in any subset,
eg Rank(Sales,Sales,true,false,subset(brand))
and Rank(Units,Units,true,false,subset(brand)

Welcome!

Categories

Ideas Parade

Tagged