Incorrect TOTAL in pivot table

[#1]

Hello, cant understand why qlikview shows incorrect total for Product Sales value in pivot table.

I am calculating product sales as val* mni

Thanks

[rubenmarin · Accepted solution]

Hi Aditi, you can change last expression to:

If(Dimensionality()>0, val*mni, Sum(Aggr(Sum(VALUES)*Sum(product_weightage), TERRITORIES, [IJSF Brick])))

Problem is mni, saleshas to multiply VALUES*weight, in totals, if you multiply by sum of weight, it multiplies by 3.18.

[#3]

Thanks  a lot. Just why are we using the dimensionality and in what all conditions it can be used?!