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

How can I add total category in a dimension?

32 Views

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....?