Need help in showing all dimensions in pivot table when there is no record

[vrb]

Hi all, I need help in showing the dimensions in pivot table when there is no record for any specific period. below is the sample data and the screenshot my pivot table. when i select programme code - BAH-KA , the dimensions going off. I want to show all the dimensions in the pivot table and show 0 when there is no record for any selection in the filter. Please help me with this.

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

[octavianus_utam]

I am not sure if there is any official way to do this.

However my usual workaround is to add 0 to the measure using Sum({1} 0), this way all dimension will always have value.