I have a chart, that has 2 dimensions (year and Half year).
As a measurement, I have the following expression:
(RangeSum( Above(TOTAL sum([Palautus yhteensä])+SUM([Maksu ulos]), 0, NoOfRows(TOTAL))))+SUM(Valuation)
Question: How do I limit the number of dimensions displayed? For example, If I would like only to display all H1/H2 from 2011 till 2016 and leave 2010 away from the chart. But As it is a cumulative formula, the values from previous years should still be displayed in the charts periods. Is this possible to do?
Thanks for the help!