2 Replies Latest reply on Nov 13, 2018 6:32 AM by Maciej Bedlin

    percentage of total before calculated "filtering"

    Maciej Bedlin

      Hi all


      so I have number of orders..  6541

      1992 were late and I got a breakdown by site and reason...

      so got sites on the rows and reasons on columns

      1992 on screen is the total of "late ones"

      now I've been asked to make same calculation but from the total number before the "filtering calculation?

      if I sue all orders for total...

      so I need all values from 1st table to be calculated as percentage of grand total from 2nd one (not as shown in yellow) of all failed and passed orders...