Displaying last records value in pivot

[ajaysingh29]

Hi All,

I would like to show item desc wise last unit cost in the Piovt table.

I have attached test QVW file, requesting your  suggestions to achieve this.

Many Thanks!

[prma7799]

Check this??

FirstSortedValue()

https://community.qlikview.com/thread/189960

[ajaysingh29]

Thanks for your reply.

Tried below, but not showing proper result. Could you help plz help me out with this.

Based on the data which is shared in qvw result should show :

         Gpc = 240

         GCC=230

         INCC=15500

         UPS=660

Thanks!

[tresesco · Accepted solution]

Try this:

FirstSortedValue(DISTINCT UnitCost, -SubField([PO Number],'-',-1))

[ajaysingh29]

Thank You!!