Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have an expression which i have to add to 9 charts.All charts are in single tab. please tell me the way where if i add expression in 1 chart; it will be reflected in all chart objects in that tab
Create a variable in the variable editor and enter the expression as value for the variable. Then use the variable in each chart. For example:
Original expression: sum(Sales)
Variable vSum: sum(Sales)
Chart expressions using the variable: =$(vSum)
If you then change the variable vSum in for example sum({<Year={2015}>}Sales) then all charts using the variable will use the changed expression.
Create a variable in the variable editor and enter the expression as value for the variable. Then use the variable in each chart. For example:
Original expression: sum(Sales)
Variable vSum: sum(Sales)
Chart expressions using the variable: =$(vSum)
If you then change the variable vSum in for example sum({<Year={2015}>}Sales) then all charts using the variable will use the changed expression.
If 9 charts are linked objects, you can make add your expression to one and the rest will be automatically updated.
You can make use of a variable containing your expression and calling that variable in every chart definitions