5 Replies Latest reply: Mar 20, 2014 10:21 AM by Alec Smith RSS

    Set Analysis  - Annual Sum

    Alec Smith

      Hello,

      I am trying to sum sales for a year based on the Year list box using the following expression. 

       

      sum({$<Year = {$(=max(Year))}>} (MainAmount)) 

       

      The issue is I am losing the annual sales sum when I select a month from the Month list box.  Other than the Year list box, I don't want any other time dimension to effect summing for the year.

       

      Thank you in advance for any help with this issue.