4 Replies Latest reply: Aug 1, 2017 9:00 AM by Steve Dark RSS

    Variable Expression for SUM

    Ramkumar Manickam

      I am trying to do bar chart with some selected month data QTY sum value only to display, so i planned to create Variable as expression to get input for Selected month. but it is not working...

       

      Variable:

      Variable Name: v2017Jun

      Expression Formula: [Calendar Month-Year - RD]= {'Jan-2017','Feb-2017','Mar-2017','Apr-2017','May-2017','Jun-2017'

       

      Expression formula i used in chart is..

       

      =(Sum({$<v2017JUN>}[RW Qty]))

       

      If i used this expression, chart accumulating all month RW QTY sum values, not which i selected month which i need...

       

      If is fixed the variable, so i can use it at multiple chart for selected month, also i will add or delete some month in future too...

       

      can any one help on this...