I'm creating a text object to calculate variances for different dimension.
I can do a general formula just to calculate ALL, but, how do i make a dynamic formula, so that, for example, when year or month or some other dimension is selected, the formula is able to compute the right figure?
For this you will have to create variables in your application. When selections are made, then changes should be reflected in a variable and these changed variables can be crosschecked using some conditions in your text object and then do the necessary operations you want to perform. here you must use the $(variable) to get the values stored in the variable. Hope this helps you.
I managed to use set analysis like Sum ({$<Year={$(=Max(Year))}>}[Amount])
But this formula only allows me to take the max year for sum.
How can i create a formula to take in all the selected values of different dimensions? For example, i want to include all the selected market, year, month? to make it dynamic.
Herewith i have attached an example for your reference. Pls check the "Variable overview" & find the expression in the text box. I hope this will help you.
