sum total is not matching with sum all the individual fields in straight table

[chandu441]

Hi All,

I am facing some kind of issue when I am creating straight table for 1 lakh records with N no of dimensions having one expression.

Expression is Sum(Gross_Sales). I am getting the Grand Total top of the Straight table is not matching when I am summing the all the individual line of rows by downloading excel from the same table.

Even i am using the Aggr function "Sum(AGGR(Sum(Gross Sales), Dim 1, Dim 2,,,,Dim N))" it is not getting workout for me.

suggest me something

Could you please help me in the issue...

Thanks all in advance

[sunny_talwar]

You mentioned that you are using a straight table, right? Have you tried changing the total mode to Sum of rows?

[chandu441]

Hi Sunny,

Thanks for your inputs

Actually the option which you have suggested I've already done that. even though I am getting mismatch in the below screenshot you can see.

Here is the sample Which I am getting mismatching data points. I have downloaded it in excel and individually sum of all rows.

[maxgro]

could you post a small example (.qvw)?

Preparing examples for Upload - Reduction and Data Scrambling

[jonathandienst]

This is very likely a problem with one of your dimensions. Its possible that some values map to more than one dimension value. That means that the sum of rows will be larger than it should be. If you post a small sample that illustrates the problem, you may get more accurate and detailed help.