Get dimension against highest spend

[anagharao]

Hi Everyone,

I have a list of hotels(along with city) and the amount spent in each for a particular date. I would like to display the top hotel city with the highest spent for the month selected in the list box.

Thanks

Anagha

[tamilarasu · Accepted solution]

May be this,

='Top hotel ' & Only({<[Hotel Name] = {"=Rank(Sum([Amount]))=1"}>} [Hotel Name]) & chr(13) &  Sum({<[Hotel Name] = {"=Rank(Sum([Amount]))=1"}>} [Amount])

[susovan]

Hi Anagha,

Try this attachment,

[anagharao]

Hi Thank you for the solution. Much appreciated

Can you help me in extending the solution to compare top city of this month with its spend in the previous month?

Regards,

Anagha