Ignore any selection in Set Analysis with AGGR SUM expression

[sully123]

Hi,

I am trying to create a completely static KPI box which shows the Month to Date sales using Set Analysis.

I have the following expression:

Sum( Aggr(Sum( DISTINCT  Sales), OrderNumber))

And have used the following set analysis:

Sum( Aggr(Sum( DISTINCT {1<YearMonth={"$(vMTDStart)"} >} Sales), OrderNumber))

But selections still affect the sales value shown despite the '1'.

Could you please help?

Thank you

[BrunPierre · Accepted solution]

Like this?

Sum({1} Aggr({1}Sum({1} DISTINCT {<YearMonth={"$(vMTDStart)"} >} Sales), OrderNumber))

[sully123]

Yes!! Thank you very much