Incoming numbers for characteristics in rows

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

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

[edwin_harpino · Accepted solution]

dear Mariana,

check if how to count occurence doc helps

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7e58e690-0201-0010-fd85-a2f...

[Former Member · Accepted solution]

Dear A.H.P:

Thank you for your help, I have resolve the problem.

Best regards.

Mariana Serrano

[Former Member · Accepted solution]

Hi Mariana,

How did you solve the problem?

Can you please share with us?

cheers,

shylaja.

[Former Member · Accepted solution]

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

[Former Member]

Hi mariana

what is ur doubt, abt creating second coloumn or anything on key figure.

if it is abt creating coloumn, then add the second key fig in coloumns during design of query.

If ur having doubt on key fig, I think it is in sales and distribution key figures

Hope it helps.....let me know

Regards

NR

*assign points for helpfull answer

Message was edited by: NR