XOR Function

[#1]

Hi All,

Could someone help me with this.

I have table as below. But i want to see rows to user who belong to any one AREA but not both or NULL

OutPut: B and C.

Thanks in advance

[Anil_Babu_Samineni]

XOR we can use like If condition -- If(XSales >= 20 or YSales <=30, 'True','False')

Can you share sample data and expected output which demonstrates the output

[PrashantSangle]

Hi,

use "\" for XOR

For details read below thread

Implicit Set Operators

Regards,

Prashant

[Peter_Cammaert]

You can accomplish this by using set analysis and an expression search.

Your original post may not be the most detailed (your table looks like an aggregated end-result instead of a base table from which to start), but you can try with a straight table that includes dimensions User & Area, and an expression like:

=sum({<User*={"=count({1} DISTINCT Area)=1"}>} [X Sales]+[Y Sales])

See also the example in attachment

Best,

Peter

[tresesco · Accepted solution]

And with increasing number of Areas, you might want to make it dynamic like:

=sum({<User*={"=count({1} DISTINCT Area)<$(=count(Distinct Area))"}>} [X Sales]+[Y Sales])