Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Have you tried this?
=Sum(Aggr(If($(v_Range),$(v_Milleage_Change),0), CODE_PRODUCT, GROUP, MILLEAGE, NUM_VEHICLE, MILLEAGE_CHANGE))
Hi Sunny , thank you very much . I guess I wasn't aggregating all dimensions needed.
This solved my problem .