Straight table calculated total row

[tom2qlik]

Hi All,

My requirement is to have a calculated total different to it's expression.

My expression is simply calling a field and I want the total of this column to be a calculation of two previously calculated expressions.

The Yield target is not a calculated so the total is not correct as can be seen as blank below.

I would like the Yield Target total to be Standard / Target so it would be 59616.55 / 58008.90

I should also point out that the standard and target columns are both expressions.

Thanks,

Tom

[prieper]

You need to tickmark Total Mode to "Expression Total"

Peter

[tom2qlik]

It didn't make a difference.

Thanks,

Tom

[Kushal_Chawda · Accepted solution]

try this expression

SUM(DISTINCT [Target Content])/

(sum(aggr(sum([Target Content])/sum(Yield_Target),Resource,Date)))

[Anil_Babu_Samineni]

I am not using server now, May be stalwar1‌ cal help you

[sunny_talwar]

kush141087‌ response should work here

//Yield_Target

SUM(DISTINCT  [Target Content])/

Sum(Aggr((SUM([Target Content])/SUM(Yield_Target)), Resource, Date))

[tom2qlik]

Worked perfectly...Thanks!