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))
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?
Retrieving data ...