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).