Need help in showing all dimensions in Pivot when there is no record
Hi all, I need a help in showing all the dimensions in Pivot table when there is no records available for a period. Below is the screenshot of what i need.
semester
study_level
Status
programme_code
fte
person_id
202209
UG
Home
BAH-KA
1
2761
202209
UG
Home
BAH-KA
1
2762
202209
UG
Overseas
BAH-AR
1
5237
202209
UG
Overseas
BAH-AR
1
5238
202209
PG
Home
GRD-LL
1
6
202209
PG
Home
GRD-LL
1
7
202209
PG
Home
LLM-ILZ
1
16
202209
PG
Overseas
GRD-AX
1
927
202209
PG
Overseas
GRD-LL
1
928
202209
PG
Overseas
GRD-LL
1
929
202309
UG
Home
BSH-AXGX
1
7518
202309
UG
Home
BSH-AXGX
1
7519
202309
UG
Overseas
BAH-AR
1
11233
202309
UG
Overseas
BAH-AR
1
11234
202309
PG
Home
GRC-SPS
1
5610
202309
PG
Home
GRC-SPS
1
5611
202309
PG
Overseas
GRD-LL
1
6350
202309
PG
Overseas
GRD-LL
1
6351
I have study level and status code, 2 dimensions in pivot and sum of FTE in measure. when i select the programme code BAH-KA and semester 202309 the dimensions in pivot table going off. I want to show all the dimension values in pivot table but show 0 in the measure when there is no record.
