Pivot table grand total not working

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.


Any help is greatly appreciated!

Nothing? :frowning: this is still a major issue and oversight

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

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.