on 07-14-2011 10:23 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Isn't it ok for you to use ranking feature to show the record with max value ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.