6 Replies Latest reply: Jul 16, 2014 5:13 AM by Tricia Chan RSS

    sum by month and year

      Aggr.PNG

      Hi, I've got a straight table with the above data.

      The YTD.Actual on the right most column only shows up in the last row.  This total is correct - the sum of dtAmount where dtYear =2013.

       

      How do I make this field static so that it will always show that amount on each of the month?  If I select any month, that total becomes wrong - it shows the same value as dtAmount.