Hi Devesh,

Check the below image

add the date field to context and apply top N on Product name based on the date filter automatically your total value will change

hope this kindly mark this answer as correct and helpful to close the thread

BR,

NB

Hi Devesh,

Follow the below steps to solve the problem

1) Create a calculated field like below

2) Click on Product name --> Create --> Set --> Top --> Select the created field (product name sales) --> 10 ok

3) Drag the set to filter

4) drag the created calculated field to text you will get the top 10 value

Original:

KPI Value:

Hope this helps kindly mark this answer as correct and helpful so that it will help others

BR,

NB

Devesh,

I see there are 2 problems here:

1- First is set does not compute RANK(). Means it won't give same rank to 2 two products if they have same sales.

2- RANK() is a table calculation. So if you don't keep the dimension on which you are trying to calculate rank, you can not calculate rank and so you can not use it as filter.

So now one option is you keep the product_name also in your view and select show totals . On the dashboard use Floating Dashboard and adjust it so that only grant total is seen

I will get back to you if I find any better way of doing it.

Thanks,

Ankit Bansal

Hi Devesh,

May i know what going wrong?

BR,

NB

Hey Devesh,

Got a work around for this. In below example let say [ID] is product_name and [mock] is sales.

First create a set of top N on [ID]: TOP_N Set :

You can pass parameter instead of 2.

Then create a calculated field as: top N Sales

Then create a calculation filter as : T|F

Then put this on filter shelf and choose TRUE. Drag the sales on shelf and you are there

Attaching the workbook for reference.