Find the top 5 values in KPI's

[Ramu_i]

Hi All,

City wise hotels are there

we can find the top 5 cities with height number of hotels

City   Count (Distinct Hotels)

Hyderabad     500

Chennai   400

Bengaluru 300

Pune   200

Delhi  100

This table is coming but requirement is only shows the city list not for value.

Thanks & Regards,

Ram

[Tanish · Accepted solution]

Hi Ram,

U can hide the column this way.

Under your measure, you have a option as Show column if , simply pass 1=0 it will help in hiding column.

Hope this will help.....

Thanks,

Tanish

[Ramu_i]

Hi Tanish,

Thanks.