Skip to Content
author's profile photo Former Member
Former Member

Displaying Dimension Name in Cell based on Max Measure Value

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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jul 15, 2011 at 03:21 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 15, 2011 at 04:25 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 15, 2011 at 02:52 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.