8 Replies Latest reply on Aug 21, 2018 10:27 AM by Dave Attrill

    Grand Totals calculation not working as desired

    Dave Attrill

      Hello everyone, I have a simple dataset showing sales and margin dollars and the percentage between the two.. however my total line is summing the percentages from the percentage column, but I need it to do a calculation based on the YTD Sales $ vs YTD Margin $ to give me a true representation of the overall margin percentage, ie 84.64/471 = 17.97% any tricks to doing this?  FYI I still do need the total column to show the dollar totals for the YTD Sales and YTD Margin so that part is working as desired.