Show Partial Total wrong

[MasterIvela]

I have a problem with partial total in table

the total shown in the graph does not correspond to the actual total of the column if exported to excel.

the difference is big approximately 1MLN.

the formnula in expression is:

if(sum(if(ANNO_BUDGET_COMMESSA=Anno_Exp,FORECAST_COMMESSA))>(sum(if(ANNO_TBL=Anno_Exp,W_FT_VALORE_NETTO))+sum(if(P_ANNO_RICHIESTA_CONSEGNA=Anno_Exp , (P_OR_VALORE_RESIDUO)))),
sum(if(ANNO_BUDGET_COMMESSA=Anno_Exp,FORECAST_COMMESSA)),
sum(if(ANNO_TBL=Anno_Exp,W_FT_VALORE_NETTO))+sum(if(P_ANNO_RICHIESTA_CONSEGNA=Anno_Exp , (P_OR_VALORE_RESIDUO)))
)

what can i check?

[MasterIvela]

I understood the problem: the total of the graph does not consider the conditions in the expression

how can i create a total row that sums the column values?

thx

[marcus_sommer]

By using a straight-table you could change the calculation-mode within the tab expression on the right bottom to the sum of y-values. By using a pivot this feature isn't available and you will need to wrap your expression within an aggr() so that your expression looks like:

sum(aggr(YourExpression, Dim1, Dim2))

whereby Dim1 and Dim2 are placeholder for the needed dimensionality  - which is usually the included chart-dimensions.

- Marcus