Counter in a query!

[Former Member]

Hi Developer,

I need to create, in a workbook, a counter. This counter must count the number of the customers who have effectued a Sales Order. Without the customer drill down we have to see the total amount of the customer who have effectued a order. Example: In Italy I have two customers with a order each without the drill down I have to see in Key figure as result 2, with the drill down for customer I have to see 1.

Thanks in advance!

Domenico

[Former Member]

I've created a key figure with a calculated index directly on the cube and It works!

I hope it helps!

[Former Member]

Thanks for your answer!

I need to count the customer indipendently from the number of the rows. For me it is important to know the number of the Customers with sales order! So without drill down I need to Know the total amount of customers. If I've 3 customers with order of sales my counter have to show 3 without drill down for customer.

[Former Member]

Did you already know this doc ?

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/how to count the occurrences of a characteristic relative to one or more other characteristics.pdf

Hope it helps!

Bye,

Roberto

[Former Member]

Domenico,

put a formula (constant) in your query or use 0ROWCOUNT from your cube...but I don't uderstand if you want customer in the rows or not !

Bye,

Roberto