It's been awhile I haven't work on Qlikview. I come across expression total doesn't foot when dimension limits "show total" are checked for Industry and Issuer. What Im trying to do is to take "Sumproduct" column divide "Excluded Issuer" = Final Column. There are 3 Issuer been excluded, "J Soft", "Risk", and "Tan". Any information greatly appreciated!
Expected Value: for Issuer and Industry Total:
Sumproduct - expect to show 27,239 not 26,946 (not sure how this number comes in)