Pivot table grand total not working

[matthijs9k]

I have a large pivot table that works as follows:

All "Activiteit groepen" have "activiteiten"

Per activity, there are locations, and each location has sublocations. Within these sublocations there are X amount of years.

The data is the hour spent on each task. The total for each activteitengroep is working, but at the bottom the end / grand total is blank and shows nothing.

Screenshots:

Any help is greatly appreciated!

[matthijs9k]

Nothing? this is still a major issue and oversight

[Luiggi]

Most probably its because you have nulls, fill the nulls with zeroes

[matthijs9k]

Thanks for your help.

I'm now coalescing the Sum of Hrs like so:

But it still produces this result:

Clearly still full empty cells / null cells to be seen. And no total either.