15 Replies Latest reply: Feb 15, 2018 4:25 PM by Fei Xu RSS

    Grand Totals in Straight Table

    Sridhar Kasthuri

      Hi All,

       

      I have issue with grand totals when looking at particular order number. Below is the scenario

       

      Sales PersonOrder NumberSales $$Total Sales $$ by Order
      ABC123200500
      XYZ123300500
      QWE456100100
      WER234250250
      Grand Total8501350

       

      Sales $$ Grand Total is looking good but Total Sales $$ by Order is adding all the numbers which is wrong it should show 850$ as well.

       

      And we have filter to one order 123 Grand Total is showing up 1000$ which is it should show only $500.

       

      How do I achieve this?

       

      Thanks

      Sridhar