0 Replies Latest reply: Feb 15, 2017 9:42 AM by jarkko pelli RSS

    Limit the number of displayed dimensions on chart



      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!