I need help for creating a column in a query.
We have several characteristics such as material, customer, country, billing document , that can be used as rows. In columns we want two key figure, one the amount of sales, and the other the number of billing documents.
We have a query where material is in rows, and in the first column appears the "amount of sales", and in the second "number of billing documents for each material".
Has anyone any idea for the second key figure?
Thanks for your attention.