Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Try like
Sum( if((PK_Date>=LastRefresh-7) or FiscalWeek='2', FTE))
The condition is unfulfilled for the total, the question is:
what are the values for
PK_Date, LastRefresh, FiscalWeek
when you summarize all?