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:



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