How add 2 filed values and add new field value in straight table

[ramrongala]

Hi All

I have some issue in straight table. i got below table in QV

But user wants like below one:

4 field values we need add this table

1) non land Total= Debenture+Guarantee+others    2) non os overall= Debenture+Guarantee+others+land

3) non os land Total= OS Debenture+OS Guarantee+OS others 4) non os overall=OS Debenture+OS Guarantee+OS others+OS land

in sales expression avg of field values

count expression add of field count

so please help on this issue. kindly check attachment of QVW and EXcel.

[sunny_talwar · Accepted solution]

Look here:

Add 2 partcular values in field-straight table