Dynamic dimesion

[Ran]

i have table  with Year and Year customer started

i am adding dimenesion  with

if (year_customer_start=getfieldselection(year),'new',

if(year_customer_start<getfieldselection(year),'existing',

'not a customer'))

after that if i choose in Filter  the year  for example 2022, the table will be 2022 and the calculated dimension will work.

but after that filter when i will want to see for example that "existing" (after  i choose 2022) its will pick all the years that include "existing"

[vinieme12]

"but after that filter when i will want to see for example that "existing" (after  i choose 2022) its will pick all the years that include "existing"

This is logically correct as the definition for Existing is (year_customer_start<getfieldselection(year))

What is the behaviour that you are expecting?

[Ran]

i want that after i choose year 2022 i will see all the customers type in the table and to filter in the table all the  existing customers without the filter of year will give me ALL 

i tried mabye to change 'existing' to Year&'existing' its fine but wanted  better solution

[vinieme12]

Then you need to build an "AsOF" data set in your datamodel