Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this:
FirstSortedValue(DISTINCT UnitCost, -SubField([PO Number],'-',-1))
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!
Try this:
FirstSortedValue(DISTINCT UnitCost, -SubField([PO Number],'-',-1))
Thank You!!