Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
"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?
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
Then you need to build an "AsOF" data set in your datamodel