topic Re: Table visualization - display top 10 rows only in App Development

Table visualization - display top 10 rows only

jerryr125 — Mon, 07 Feb 2022 18:50:23 GMT

Hi -

I am stuck on this one.

I have a table visualization with six columns :

Location, Major Category, Minor Category, Sub Category, Product Name, Quantity Sold

Location, Major Category, Minor Category, Sub Category, Product Name are all dimensions
I set the limitation to 'top 10' and turned off the 'Show Others'
For the dimensions it states "Calculated on Measure: Quantity Sold"
The Quantity Sold is a measure : sum(quantity sold)
I have sorted the table by Quantity Sold

I only want to show the highest 10 (top 10) quantity

This is not working - it displays all records (and there is 1000's of records).

Any thoughts ? thanks - Jerry

Digvijay_Singh — Mon, 07 Feb 2022 23:40:02 GMT

If possible try to use rank function inside the measure.

The dimension limit even if you set for each and every dimension, sometimes the overall combination won't give you only 10 rows.

anat — Tue, 08 Feb 2022 06:21:01 GMT

Sum({<Product = {"=Rank(Sum(Sales)) <=10"}>}Sales)