I'm finding myself using alot of set analysis to cancel out prior selections for specific charts etc.
I'm finding that there are upto 6 or 7 individual expressions that i'm having to cancel out for multiple charts. I'm having to create these same expressions in every chart or object.
Is there a quick way to apply multiple set analysis expressions to a chart rather than having to replicate them each time. Is there a way to create a 'set' of set analysis expressions that can be applied all at once.
Create a variable called Set_Analisis_Clear and store the part of set analysis that you repeat (In this case the variable has the value Year=). Then in the expression put expand the variable like below:
Actually for all expressions that are repeated more then one time, it is more efficient to maintain them when you declare the expressions as variables and then expand them.
Create a variable called Set_Analisis_Clear and store the part of set analysis that you repeat (In this case the variable has the value Year=). Then in the expression put expand the variable like below:
Actually for all expressions that are repeated more then one time, it is more efficient to maintain them when you declare the expressions as variables and then expand them.
