3 Replies Latest reply on May 20, 2016 1:59 PM by Joe Oppelt

    Total of Calculated Field no matter Filter

    Jerry Ward

      I am trying to do a calculation on data which I have in a filter but I just want the total of the amount always shown in the table no matter the filter.

      Days Range          Jan          Feb       Mar      Apr       May       Jun

      30 Days              $100     $100     $100     $100     $100       $100

      60 Days              $100     $100     $100     $100     $100       $100

      Total                   $200     $200     $200      $200     $200       $200

       

      We want to filter the data based on the '30 Days' and '60 Days' and the Total to stay on the table of $200 no matter the FILTER.

      Right now if we were to filter on 'Days Range'  The total will decrease to $100 or other, when we want it to always show $200.