Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have some dimensions : Product1, Product2, Product3, ...I'm using those dimensions in set analysis
I have a filter to select the numero of the product (1, 2, 3 ...)
Is it possible to set a variable to determine the dimension ?
Equivalent to :
if(getfieldselection(value) = 1, sum({<Product1={something}>} measure),
if(getfieldselection(value) = 2, sum({<Product2={something}>} measure),
if(getfieldselection(value) = 3, sum({<Product3={something}>} measure),
))))
I would like something like :
myvariable = 'Product'&getfieldselection(value)
to do sum({<myvariable={something}>} measure),
Perhaps this
sum({<YourKey={"=$(myvariable)=something"}>} measure)