Ignore filter dimension in formula

[SaraKalemba]

Hi, 

I use formula 

Sum(Aggr(FirstSortedValue({<RAC_DIMENSION={'CUSTOMER'}>} PURE_CHURN_60D, -Aggr(Max({1<RAC_DIMENSION={'CUSTOMER'}>} CONTACT_TIMESTAMP),[Year-Month], PARTY_ID)),[Year-Month],PARTY_ID))

When no filtering is set on [Year-Month], he gives me the evolution in graph:

But when I select the filter [Year-Month] (ex. Oct/20), he will not ignore the filter and only display the value of Oct/20 in the Graph. I tried to added "[Year-Month]=" or "1" at several places but do not get it to be ignored.

[pradosh_thakur]

Sum(< [Year-Month]=>{}Aggr({< [Year-Month]=>}FirstSortedValue({<RAC_DIMENSION={'CUSTOMER'}, [Year-Month]>} PURE_CHURN_60D, -Aggr(Max({1<RAC_DIMENSION={'CUSTOMER'}, [Year-Month]>} CONTACT_TIMESTAMP),[Year-Month], PARTY_ID)),[Year-Month],PARTY_ID))

[SaraKalemba · Accepted solution]

Sum({<[Year-Month]=>}Aggr({< [Year-Month]=>}FirstSortedValue({<RAC_DIMENSION={'CUSTOMER'},[Year-Month]>} PURE_CHURN_60D,-Aggr(Max({1<RAC_DIMENSION={'CUSTOMER'}, [Year-Month]>} CONTACT_TIMESTAMP),[Year-Month], PARTY_ID)),[Year-Month],PARTY_ID))

Thanks, It works perfect. I just needed to place first {} to have an OK 🙂