I need to make a sum for different options.
Example:
The order for account A is 10. We have failed to deliver 1, which is marked as "failed". (in the tabel 2 rows, commom dimensions are accountnr and ordernr)
The order for account B is 100. We have delivered all.
I need the following result:
Ordered Delivered Not delivered
Account A 10 9 1
Account B 100 100 0
How can I proceed? Best to use Rowno or Recno? Or something else?
Thanks!
