Help needed in the below expression

[Anonymous]

Hi

=aggr(

  If(sum({$<Customer_ID, Cust_Year,Category, Product={'Global','State'},Year={">=$(=max(Year)-1)"}>}Value)

  >= v_Quartile1,

  'Over ' & num(v_Quartile1/$(v_Measure), '$#,##0.0'),

If(sum({$<Customer_ID, Cust_Year, Category, Product={ 'Global','State'}, Year={">=$(=max(Year)-1)"}>}Value)

  < v_Quartile2,

  'Under ' & num(v_Quartile2/$(v_Measure), '$#,##0.0'),

)) ,Cust_Year))

In the above expression if i select some values in  filters for category and Product, the values are changing. I want these filters to be ignored irrelevant of the selections we make in filters.

John

[sunny_talwar]

Give this a shot:

=Only({<Category, Product = {'Global', 'State'}>}

  Aggr(

  If(Sum({$<Customer_ID, Cust_Year,Category, Product={'Global','State'},Year={">=$(=max(Year)-1)"}>}Value)

  >= v_Quartile1,

  'Over ' & num(v_Quartile1/$(v_Measure), '$#,##0.0'),

  If(Sum({$<Customer_ID, Cust_Year, Category, Product={ 'Global','State'}, Year={">=$(=max(Year)-1)"}>}Value)

  < v_Quartile2,

  'Under ' & num(v_Quartile2/$(v_Measure), '$#,##0.0'))), Cust_Year))

[maxgro]

maybe you have to disregard category and product also in

max(Year)

[Anonymous]

Thnx Sunny, Actually I tried with Only({1} Aggr expression) but it didn't worked, may i know how different it would behave.

John

[sunny_talwar]

Not much, I guess try maxgro‌'s recommendation

[Anonymous]

Sure Maxgro, will try  this..

John