Using Calculated expression as a filter in Set Analysis

[Anonymous]

Hello All.

I am struggling in a problem with a slider and a variable.

I have to filter the data in the table based on a variable , it's working fine , but the user can hide\show the columns that I use to calculate this variable, when the columns are hided I only get wrong results or error.

I tried to use Aggr and Set Analysis , but I couldn't make it work out.

Has anyone seen anything like that? I attached the example.

Thank you very much .

[sunny_talwar]

Have you tried this?

=Sum(Aggr(If($(v_Range),$(v_Milleage_Change),0), CODE_PRODUCT, GROUP, MILLEAGE, NUM_VEHICLE, MILLEAGE_CHANGE))

[Anonymous]

Hi Sunny , thank you very much . I guess I wasn't aggregating all dimensions needed.

This solved my problem .