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

    Limit the number of displayed dimensions on chart

    jarkko pelli

      Hi,

       

      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)

       

      pic1.png

       

       

      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!