Values in a Pivot table not adding up to the total? Is it a bug?

[#1]

Hi everyone,

I have loaded excel data into the application and was trying to make a pivot table. But seems like qlikview is not adding up the number. Does anybody know if it is a qlikview bug or do I have to do any transformation to the numbers? Attached is the problem causing pivot table image. Any help is greatly appreciated.

Thank you

Suraj

[chiru_thota]

Interesting....Can upload your QVW by scrambling data ?

[#3]

Sorry Chiranjeevi could not upload the file. But its a plain load of excel and the expression is direct sum(column). It is so annoying cannot identify the problem. I tried doing the sum in a text object as well, so it not a pivot table issue for sure.

~Suraj

[Anonymous]

You can provide a sample data and you can scramble it.

So that we can not see ur data.

Its strange that values are not being summed up.