I'm looking for a way to play with data from ERP system. Idea is to create a dashboard which shows list of customers and status/qty of orders.
I was able to get the data from Excel file to NR. Structure of excel table and massage payload are show in the picture.
Question is how to sort the data by customers ( column C) and sum q'ty (column N) ?
Thanks for advise.