set analysis issue

[slribeiro]

Greetings.

I want to put in a variable how many countries I have which has sales in the period I've created with a flag.

I have the following but something's wrong.

=count(DISTINCT {<YTDFlag={'1'},Country={"$(=sum({<YTDFlag={'1'},...other  set analysis...>}Sales))>0">} Country)

Thanks in advance

[sunny_talwar · Accepted solution]

Try this:

=Count(DISTINCT {<YTDFlag={'1'}, Country={"=Sum({<YTDFlag={'1'},...other  set analysis...>}Sales))>0"}>} Country)