Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have to get a result like:
Sales of the persons who bought only product A.
If we have multiple persons who bought products with different categories. So i want only those persons sales who bought only product A but not product B,C, D ---
Thanks,
Narender
or
=SUM({<product = {'A'}, person = {"=COUNT(Distinct product)=1"}>}Sales)
Something like this
=SUM({
<person = {"=COUNT(DISTINCT product)=1"}>
*
<person = {"=COUNT({<product = {'A'}>}DISTINCT person )=1"}>
}Sales)
or
=SUM({<product = {'A'}, person = {"=COUNT(Distinct product)=1"}>}Sales)
Thanks for your reply Manish.
Can you please explain your last one expression??
Thanks,
Narender
Sum the Sales for Product A from people who only bought one product (which by inference is product A)