9 Replies Latest reply: Sep 21, 2016 9:28 AM by Sarah Nguyen RSS

    % by month

    Sarah Nguyen

      Hello:

       

      Dimension: MonthYear and then FinancialClass

      Measure: -Sum({<[TransPostedDateCalendar.MonthsAgo]={">=1<=4"}>}Payment_Total)

       

      How do I calculate % by month? E.g. For June 2016, total payments was $27,888. The financial class *Unmapped* would be 79%, Blue Cross would be 9%, etc. I need each month to total 100%.


      Thank you.

       

      f49c999095074fafb0efbe69b2547065.jpg