Former Member

# Counter in a query!

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.

Domenico

10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on May 26, 2005 at 08:22 AM

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

10|10000 characters needed characters exceeded
• Former Member
Posted on May 26, 2005 at 08:32 AM

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.

10|10000 characters needed characters exceeded
• Former Member
Posted on May 26, 2005 at 08:41 AM

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

I hope it helps!