Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to produce a visualization displaying SALES by REGION using two states (Group 1 and Group 2)
Sum ({"Group 1"}Sales)
However, I also want to filter the sales by a specific PRODUCT (let's call it ABC)
How do I add this to the set analysis? The following does NOT work:
Sum ({<"Group 1",[Product]='ABC'>} Sales)
Sum ({"Group 1"<[Product]={'ABC'}>} Sales)
Sum ({"Group 1"<[Product]={'ABC'}>} Sales)
That worked. I can't thank you enough, Rwunderlich