Calculate a new total expression in straight table

[Lily]

Hi All,

How can I create a manual total calculation in an expression rather than utilizing the auto total calculation in a straight table in Qlik Sense?

The values in my actual data were all positive. To get the correct grand total, as seen in the screenshot below, I need to do manual calculation. Please give me an advice if you have any. Thanks. 

[Arek92]

Hello,

In your expression you can use condition

If(Dimensionality() = 0,  Expression for Total,  Standard expression )

[Lily]

Hi Arek, 

Thanks. The expression does work for me.  But when I tried to filter by type, the value will be zero. Do you know why this happens?