cancel
Showing results for 
Search instead for 
Did you mean: 

Total Label in Drill down reports

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks!!. It really helped.