I would like to create a pivot table in which you can get the last balance of product and its version as the last value of all values. See in my attached xls file. One product and its version could be located at more than one Place and also within Place in more than one PlacePoint.
Dont need to know last balance of the day, only get last balance of product and its version.
Final Pivot:
Product ProductVer balance= calculated as a sum of balances at all places and placepoints
L111 ver1 200pce
L111 ver2 150pce
L133 ver1 20pce
I tried to use the firstsortedvalue, but it returns some other values i want to get.
Thanks for your help,
Martin
ECG line chart is the most important visualization in your life.
