on 08-07-2015 6:54 PM
hello gurus..
here my requirement is ... i am taking objects as country,state,sales revenue in web intelligence..i drag & drop" yr,sales revenue"
but i want max state sales revenue instead of yrs sales revenue...so i have used for each formula { =max([sales revenue]) foreach([state]) }
now it gives max state sales revenue but i want that state name too....
You can use the above formula but it can give you #MULTIVALUE in case of tie.
If you are likely to face such problem, you can use another way:
This will give you separate rows for states in case of tie.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For your purpose you can use following formula:
=[State] Where(Rank([Sales revenue];[State];([Year]))=1)
I hope this will help you.
Thanks,
Swapnil
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 | |
25 | |
12 | |
9 | |
7 | |
6 | |
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.