on 09-13-2010 7:21 PM
This is a simple case scenario. I created one drill down report by Country --> State --> City and set this object as section. It has revenue Column in it. Now I did Summation on the Revenue column and it shows like this
USA -- (Section)
Column1, Column2
XXX, 3
Sum, 3
Now instead of Sum, I would like the label to replace it with country name and when I drill down to second level, it should replace it with the State name and again on level 3 replace it with City name.
Could anyone help me on achieving this. Is it doable? I have been trying to achieve this but had no success.
Thanks for your help in advance.
Rids
Yes, It can be achieved with the help of the DrillFilters() function.
You can build the logic using if-else condition. Here is the one for you:
=If(Drillfilters([City])<>"") Then [City] Else If(Drillfilters([State])<>"") Then [State] Else If(Drillfilters([Country])<>"")
Then [Country]
Regards,
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
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.