2 Replies Latest reply on Oct 2, 2018 6:02 AM by Janet May

    Column Table Calculation

    Janet May

      Hi All,

       

      I am having some difficulty calculation the % of the total / month. The table below is an image of the responses:

       

      and I want to get the percentages for each month (below is just an image of a quick calculation I did in Excel for the month of august only).

       

      Normally I would think this calculation is easy - but unfortunately the counts you see above are based off of a table calculation where August is a rolling (row across) total of June, July and August... July is a rolling (across) total of May, June and July etc. So when I try to run a table calculation an error happens because I am stacking two table calculations on top of one another.

       

      The calculation for the rolling total count is as follows:

      WINDOW_SUM(COUNT([Response]),-2,0)

       

      Any insight on how to make this work would be much appreciated!

       

      Thanks