Hy there , I have a Straight table with 4 dimensions . For each dimension I have calculated what to show using nested if statement.
The statement looks something like this :
if(Match(ID,GetFieldSelections(ID)),ID,if(Match(NO,GetFieldSelections(NO)),ID,if(Match(DATE,GetFieldSelections(DATE)),ID)))
But this nested IF`s makes the proccessing real heavy . Is there any other way to acomplish the same behavior without using this calculated dimmension?
Thank you.