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??