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.

[pradosh_thakur]

Hi

hopefully this is what you are looking for.

regards

Pradosh

[Anonymous]

Thank you Pradosh, Prashant  & Frank.