EXPRESSION

[upaliwije]

I have  Pivot table in my qvw file where I don't get the expected output. My current output and expected output   is shown below

The rows where changes are needed shown in red color. In fact What I need is when there are values in  both column it should be nett off and balance shown in one column. Kindly help me correct my expression to obtain desired results.

[tresesco · Accepted solution]

Please find attached a solution. I have used straight table instead of pivot because of two reasons: 1. You are not reporting a hierarchical data but a flat one and that can be simply reported using straight table. 2. You can use simpler expressions without aggr() to improve app performance.

[upaliwije]

Thanks Tesesco,

It works but Total Value  row is not shown in the Straight Table