Add calculated difference row in pivot table

pranali_gawde — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to add row in pivot by calculating difference of two other rows of outstandingg Amount.

But i got incorrect value.please help me to figure out what is the issue or else some other method to calcullat it.

here is the snapshot of output and script.

diff:

Load

"SEGMENT CODE" as diffseg,

OS_Date ,

OS_Date as diffosdate,

"LOCATION NAME" as diffLocation,

"OUTSTANDING AMOUNT" as diffout

resident Out;

Concatenate

Load

"SEGMENT CODE" as diffseg,

OS_Date,

'Diff' as diffosdate ,

"LOCATION NAME" as diffLocation,

"OUTSTANDING AMOUNT"-Previous("OUTSTANDING AMOUNT") as diffout

Resident Out ;

topic Add calculated difference row in pivot table in QlikView