Error in Pivot Table totals - only "-" show

[#1]

Hello everyone!

I meet a strange error with Qlik Sense Pivot table: it's unable to calculate the total values by dimension:

(I edited out some details due to confidential problem)

I don't use any custom calculation or Aggregation for the measures.

I also tried to use formula to set the measures values = 0 if null / blank, but then the total also = 0.

Data structure:

The 3 dimensions DIM1 DIM2 DIM3 has a hierarchy relationship as shown in the first pic.

Could someone please help me fixing this?

Thanks a lot in advance!

[sunny_talwar]

What is the expression you are using? Can you try this:

Sum(Aggr(ExpressionPlaceHolder, DIM1, DIM2, DIM3))

Replace your original Expression with the ExpressionPlaceHolder above