cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying Dimension Name in Cell based on Max Measure Value

Former Member
0 Kudos

Hello,

I have the following data in a WebI Report:

Dimension /// Measure Value

AAA /// 3

BBB /// 5

CCC /// 8

DDD /// 2

I would like Dimension name with the highest value to be displayed in a blank cell. In this scenario I would like to see "CCC"

I have tried using the Max() function to no avail. Max(Dimension) will always give "DDD" since that starts with the largest letter of the alphabet.

Has anyone done this successfully before? Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

michael_melters
Advisor
Advisor
0 Kudos

you cannot appy a ranking on a blank cell therefore you have to make a table look like a blank cell:

Apply a ranking Top 1 on dimension

Delete the column with the measure

Delete the table header in properties the table -> uncheck show table header

Hope this helps

Michael

Former Member
0 Kudos

Thank you to everyone that replied. I was able to put ranking on a table and fake it to look like a free cell like described above.

Answers (2)

Answers (2)

Former Member
0 Kudos

Yeah all you could do is duplicate the table add ranking to the block. put a filter to retrieve the top rank. hide out all the cells except the dimension name and make it look like a blank cell.

Thanks,

Karthik

arijit_das
Active Contributor
0 Kudos

Isn't it ok for you to use ranking feature to show the record with max value ?

Former Member
0 Kudos

Make use of ranking or you can go ahead with report level filters .

Hope thses will solve your issue