2 Replies Latest reply: Dec 31, 2012 3:15 AM by Gerhard Laubscher RSS

    Variable in Chart Expression

    Gerhard Laubscher

      Hi There,

       

      I have a chart where I want users to be able to select the Month's data they want to look at.

       

      I set up a variable called vSelectMonth with value =GetCurrentSelections([Posted Month])

       

      Then in my chart I use this expression:

       

      Sum({$<[Posted Month]={$(=vSelectMonth)}>}[Trans Amount])

       

      But is is not working (retuns zero).

       

      I've tried adding double and single quotes, no luck.

       

      Would be great if someone can assist (or give me a better way of using specific selections in a chart's expression).

       

      Thanks,

       

      Gerhard