2 Replies Latest reply: Mar 22, 2015 5:32 AM by Gyanaranjan Tripathy RSS

    YTD monthly expression not working in SR6, works in SR2

    Gyanaranjan Tripathy

      Hi,

      I have a requirement, where i want to show YTD monthly accumulation in bar chart.

       

      e.g- If i select month as Jan, i should see all values for the measure for jan, if i select feb, it should be accumulation of jan & feb.

      In the same bar chart i should see both jan & feb trend.

       

      I used the below expression.

       

      Rangesum(above(sum({<[Month]={'<=$(=max([Month]))'}>}[Sales Triggered]),0)) with full accumulation in expression.

       

      My dimensions are 'Sales Month' and another cyclic group with 'Country' & 'Continent'.

      For one country, the Sales Triggered value is 0 for Feb month but for jan it's 5. So i should see 5 in jan & 5 in Feb also (5+0=5)

       

      Strange is that it's working fine in SR2 QV11 but not in SR6/SR8.

       

      Please help on this.

       

      Thanks in advance