cancel
Showing results for 
Search instead for 
Did you mean: 

Incoming numbers for characteristics in rows

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

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

Former Member
0 Kudos

Dear A.H.P:

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

Best regards.

Mariana Serrano

Former Member
0 Kudos

Hi Mariana,

How did you solve the problem?

Can you please share with us?

cheers,

shylaja.

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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