Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I calculated the forecast of the available budget for four products. For every product I have a single table with the columns Volume and date. By adding the date as the date a the dimension for the line chart and adding the sum of the budget for the four individual products as measures I was able to achieve a line chart with four lines as expected.
No I want to add the functionality to display and hide the individual lines. Therefore I created a new table with inline load containing the four names of the products.
For the measures I have the following function = IF(product='a',Sum(volume_a))
This works if I select one single product but I am not able to select several lines to be displayed in the chart.
What do I have to change to display several lines at once?
Try this
Create a variable
vSelectedProducts. Set its initial value to an empty string
=IF(Match(product, $(vSelectedProducts)), Sum(volume))
It seams not to work.
The $ seams to be not allowed in this function as I receive the error that at least 2 parameters are required for the match and without the $ nothing is displayed.
Is there an other option to do this or did I do something wrong?