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

vrb — Fri, 15 Nov 2024 21:23:31 GMT

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

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

octavianus_utam — Thu, 29 Feb 2024 11:55:35 GMT

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.

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

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

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