Help with pivot table & range sum/avg

[Anonymous]

Hi Experts,

I have data like shown below

Want to show result in Pivot table like shown image below:

Remaining column shows Oqty-Rqty

Received shows Recdate-Orderdate (its total is avg)

I have attached sample qvw for your suggestions.

Could you please help me to achieve this in qlikview?

Thanks you in advance.

[devarasu07]

Hi,

Refer to the attachment,

[Anonymous]

Hi Devarasu,

Thank you for your reply, however i think your attachment  is for diff question.

Also, in image remaining qty is not showing desired output its showing total 230 qty is remaining for 42 ordered qty.

Again thanks for trying to help.

[qliksus]

How did you get the total as 17.22 for the remaining column ?

[Anonymous]

thanks for your reply,

That i have calculated in excel , its just order qty-sum(received qty).

Is their any way by which we can achieve this in qlikview ?

kindly provide suggestions.

Thanks,

[Frank_Hartmann]

see attached file

hope this helps

[PrashantSangle]

Hi,

Please find attachement.

Regards,

[Frank_Hartmann · Accepted solution]

or maybe like attached, including total values:

hope this helps

[Anonymous]

Hi Prashant & Frank,

Thank you so much for your help!!   Both of yours solution are correct & suffice to my requirement. 

However I can mark only one correct Ans, what to do

[Frank_Hartmann]

your choice 🙂