Expression total vs Sum total

[#1]

Hi,

Can someone explain how my expression total can differ from the Sum total, as the expression is a Sum([value])

Thanks.

[Jason_Michaelides]

What are the dimensions of the pivot table? Can you post an image of the data model?

[#3]

Hi,

I attached an excel file to show the issue..

[Jason_Michaelides]

And the Data Model?  As a general rule you should not perform calculations on key fields as you have done here (N-2).  You can get unpredictable results...

[#5]

[its_anandrjs]

Hi,

I think there is aggregation need according to the dimensions where you are need to sum the values then it will show correct value.

Rgds

Anand

[Jason_Michaelides · Accepted solution]

The relationship between N-2 and Quarter has to cross the PO table.  Is there definitely an association for very record? I think you may need to work on your data model a bit first.  Which table is the fact table?  Looks like the PO table is, as there is a date, but Value is on tab1-1.  If you improve the model you may find the results tally with what's expected.

[#8]

Hi Jason,

And first of all thanks for all the help.. The issue was with my data model.

Thanks everyone

[Jason_Michaelides]

Glad you got it sorted.  Please be sure to mark helpful/correct answers for others to see.

[its_anandrjs]

Hi,

If it seems you the data model not work well try to remove unnecesary field from the tables or make a child table if necesary on the model and make a primary keys to get data from the child tables. Also when ever you check that the table is not more use try to map that table.

Rgds

Anand