6 Replies Latest reply on Jan 10, 2014 7:45 AM by Aaron Clancy

    Sum two moving sum measures

    darrennorris

      Hi

       

      I have a table with two measures showing rolling 12 months totals (moving sums) by month, e.g. Products sold and products returned. Each month shows the total for the previous 12 months.

       

      How do I perform a calculation on the two. Quite simply I want to work out the percentage of products returned against the products sold but in a rolling 12 months. The statement SUM([Products returned]/[Products sold] only peforms the calculation for the individual month and does not take into account the 12 month sum in each of the measure rows.

       

      Thanks