on 2006 Mar 27 9:22 AM
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
Hi,
Create new formula . Right click the formula --> properties. There set calculate result as and caluculate single values to " count all values".
In rows include material,billing doc.
shylaja.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Shylaja:
I have made this before using in Properties of the key figure "calculate result as.. " count all values and in "calculate single values as.." suppress result; but it is not work as we wish. The problem is that my boss do not want to see the characteristics billing document in rows, only its number for each material or customer.
Thanks
Mariana Serrano
dear Mariana,
check if how to count occurence doc helps
Hello:
I have resolved the problem using "Calculated key figure". I have created one, and in its Properties I have pussed "Enhance" and indicated the following:
- Exception aggregation: counting all values.
- Reference characteristic for..: material.
So I have managed resolve the matter.
Regards.
Mariana Serrano
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.