Skip to Content
Former Member
Mar 27, 2006 at 08:22 AM

Incoming numbers for characteristics in rows


Hello everybody:

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.

For instance:

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.

Mariana Serrano