Pivot table totals

[MikeJones]

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