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.
