Skip to Content
author's profile photo Former Member
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.

Thanks in advance!

Domenico

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2005 at 08:32 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.