Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my current code which isn't working properly but showcases what I'm trying to do:
sum({<[CustomerType]*={"1"},[Location]*={"United States","Canada"}>} {<[CustomerType]*={"2","3"},[Location]*={"United States","Mexico","India"}>} [Sales])
In other words, I want the sum of Sales to display data for CustomerType 1 only if they're in the United States or Canada as well as CustomerTypes 2 and 3 only if they're in the United States, Mexico, or India. I can't use one single set for this requirement because, for example, it would include India data for CustomerType 1 which I do not want.
Is what I'm trying to do possible? How do I format the code?
Try this:
sum({<[CustomerType]*={1},[Location]*={[United States],[Canada]}>} + <[CustomerType]*={2,3},[Location]*={[United States],Mexico,India}>} [Sales])