2 Replies Latest reply: Jul 8, 2015 5:36 AM by Alessandro Saccone RSS

    Pivot Total Missing ??

    Phil Speight

      I have created a pivot table, but for some reason one of my columns does not show the total.  The script behind this is as follows:

       

      if((PK_Date>=LastRefresh-7) or FiscalWeek='2', sum(FTE))

       

      Any ideas??

       

      Qlik_Pivot.png