11 Replies Latest reply: Feb 22, 2012 7:05 AM by Muralidhar Koti RSS

    Set Analysis help

    Muralidhar Koti

      Hi,

       

      I have a requirement to show a bar chart for year wise sum of amounts. For this I have created a bar chart with 'Year' as dimension and 'Sum(Value') as expression. This is working fine.

       

      But my requirement is, in each bar where it is showing data for that year I want to show data for >= that year. Means bar for 2010 should show sum of all values where year >= 2010 instead of year = 2010. The same should happen for 2011 bar and etc..

       

      COuld you please help me with an set analysis expression to achieve this.

       

      Sample qvw attached with this post.

       

      Regards,

      Murali