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.
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!