Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, columns 1 to 3 are output from a pivot table where the totals are showing as an average. The set analysis that I have used is shown below the table.
How can I get the pivot table to show the column Outcome Desired - the average for Monday to Friday? The 141 in column 5 is the average for Monday to Friday.
1 | 2 | 3 | 4 | 5 |
Day | Staff | Staff | Outcome Desired | |
Totals | 105 | 101 | 141 | |
2023-09-17 | 5 | 0 | 5 | |
2023-09-16 | 22 | 0 | 22 | |
2023-09-15 | 139 | 139 | 139 | |
2023-09-14 | 144 | 144 | 144 | |
2023-09-13 | 140 | 140 | 140 | |
2023-09-12 | 142 | 142 | 142 | |
2023-09-11 | 142 | 142 | 142 |
Column 2 uses the following expression
Num(sum(Aggr(count({<JobType-={'XXXX'},[QLIK_locationsDates.Date]={"<$(=Today())"},[QLIK_Jobs.Client]={'YYYY'},OutcomeResource-={"*ZZZZZ*", "*AAAAA*"}>} distinct OutcomeResource),[QLIK_locationsDates.Date],OutcomeResource)))
Column 3 uses
Num(sum(Aggr(count({<JobType-={'XXXX'},[QLIK_locationsDates.Date]={"<$(=Today())"},[QLIK_Jobs.Client]={'YYYY'},OutcomeResource-={"*ZZZZZ*", "*AAAAA*"},Weekday={"<5"}>} distinct OutcomeResource),[QLIK_locationsDates.Date],OutcomeResource)))
Weekday - this is calculated within a table using the following Weekday = Num(WeekDay(PlannedDate))