Pivot Total Missing ??

[Anonymous]

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

[swuehl · Accepted solution]

Try like

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

[alexandros17]

The condition is unfulfilled for the total, the question is:

what are the values for

PK_Date, LastRefresh, FiscalWeek

when you summarize all?