Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a sales person table in that i have 5 persons. I want to find the revenue for 2 sales persons and revenue for the rest.
In the If condition how can i check. Is this like this?
IF(Sale_person = ('A' and 'B'), Revenue, Revenue)
-Raghu.
If(Sale_person = 'A' Or Sale_person = 'B',Revenue,Revenue)
I guest you incase of A and B you want the revenue to be summed up, ..if so u need to Edit the dimension
If(Sale_person = 'B','A',Sale_person)
and expression will be Revenue only without any if condition.
Hi Raghu,
if u want to sum of A and B Revenue togather and Sum of other 3 togather then you can do like this
Sum(IF(Sale_person='A' or Sale_person='B' ,Revenue,Revenue)
but i want to know against which dimention you want to show this Sum i.e(in the Script or in the chart)
Hope this will help you
In the Dimension you should enter
IF(Sale_Person = 'A' OR Sale_Person = 'B', Sale_Person, 'others')
if you wish to see just the revenue of the two person, the expression you should enter as
SUM(IF(Sale_Person = 'A' OR Sale_Person = 'B',Revenue))
HTH
Peter
Thanks Guys for your suggestions.
Peter -- I cannot restrict in the dimension, because i have combine A & B only and for other i have to show their revenues. It would be better to give in the expression only.
-Raghu.