Difference chart total and details

[tim_leijen]

Hi guys,

Below I've created a straight table on our dashboard, however the details of the table don't match with the totals the same table is generating.

The totals are correct, any idea how this works?

[Anil_Babu_Samineni]

What expression you used?

[tim_leijen]

See print screen below, I'm using Dim for this table so the user can select several options like volume, cogs etc

[Anil_Babu_Samineni]

Would you able to provide Mock up?

[tim_leijen]

Sorry Anil what do you mean with mock up?

[Anil_Babu_Samineni]

I would refer work file

[sasiparupudi1 · Accepted solution]

Change the total mode from expression total to sum of rows for each expression.This option is available on yhe expression tab

Hth

Sasi

[tim_leijen]

Thanks Sasidhar, this actually worked!