Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to build an expression that incorporates 1) ignoring selections in certain selection boxes, 2) summing sales for all possible values except the selected value for some selection boxes and 3) summing sales for the selected value for some selection boxes. For example:
So, some selection boxes need an 'exclude selected' logic and some selection boxes need an 'include selected' logic. Is this possible?
I've tried combining '1-$' and '$' identifiers in a set analysis expression unsuccessfully. I appreciate your help with this!
Thanks,
Deniece
NOTE: I'm editing this post to attach an example file of data that I would like to have the logic above applied to. Thanks.
not sure, it should work. i haven't inlcuded AccountFlaga nd CustomerGroup at all in my set, to select excluded thats the expression in the set Region=e(Region)
are you sure you are using your fieldnames as you have and no errors in the expression?
Yes and Yes. I'm selecting the fieldnames from the selection list and there are no errors in the expression.
Moved the example file to the original post for ease of finding.
i tested in your application below expression works as per your requirement
sum({<MonthYear,SiteLocation,Region=e(Region)>}Sales)
* unfortunately i cann't upload anything to external site. i just used the above expression
Thanks. This solution works today. Perhaps I needed to reboot my machine yesterday because it was not returning the expected result yesterday.