8 Replies Latest reply on Jul 28, 2016 9:03 AM by Sam Fleisher

    Grand Total - Sum of count, countd, and percentage

    Sam Fleisher

      Hi,

       

      I have a data set that I am trying to create a work around of sorts for the total line.  The first column data points on each row are a countd.  For these, I want the total to sum those rows.  Next column is a count but also want total to sum.  Finally, third column divides second column by the first one and I need the total line to perform that same division and not sum or take average of that column.  Attached is an excel of what I'd like the final calculations to do.

       

      Is there a way forwards or work around to have control over total line like I am describing?