Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thanks Tesesco,
It works but Total Value row is not shown in the Straight Table