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