Set Analyis: Complete set restricting 1 field on Current Selection

[#1]

Hello,

I'm trying to figure out if it is possible to create a measure for the total sales in the selected month, disregarding all other selection.

I have tried te following: SUM( {1<month = {$}>} Sales)

But this doesn't work. Any ideas?

Kind regards,

Daniel

[stephencredmond · Accepted solution]

Hi,

Try:

SUM( {1<month = {$(=Concat(month,','))}>} Sales)

Stephen

[#3]

Thanks!