Skip to Content
Former Member
Jun 29, 2016 at 05:28 AM

How can I add total category in a dimension?


I am trying to create a dimension that will show:

If Peter, then Area 1

If John, then Area 2

If both Peter and John, then Country 1

I wrote the following variable using IF & Else IF.

But it is not working.

=If([Salesmen Name]="Peter") Then ("Area 1")

Else If([Salesmen Name]="John") Then ("Area 2")

Else If([Salesman Name] InList ("Peter";"John")) Then ("Country 1")

End results will look like this:

Area Sales Area 1 100 Area 2 200 Country 1 300

Could you please advice me how I can achieve this....?