Question Re: top % query in Technology Q&A

top % query

Former Member — Wed, 19 Mar 2008 10:50:45 GMT

Hi all,

It's possible to get in my query the customer that have 50% of the total sales without using condition?

Thanks a lot

Gianmarco

Re: top % query

Former Member — Wed, 19 Mar 2008 10:56:42 GMT

Gianmarco,

If you use a formula of type % Result you'll get it...but also the sales % of the other customers. are you ok with this or you just one one row of data?

Regards,

Alberto Sabate

Re: top % query

Former Member — Wed, 19 Mar 2008 11:00:53 GMT

Thanks but it's not ok, I need to see only the customer with 50% of sales without condition beacause in this case I get wrong partial result.

Any suggestion please?

Gianmarco

Re: top % query

Former Member — Wed, 19 Mar 2008 11:31:23 GMT

Ok..No problem...what about the following..

Create query 1...Here you use condition to get exactly that customer with the specific amount of sales.

Then create Query 2. Here use a variable for the customer of type Replacement (type Query).

So this is how we can get your customer without a condition in Query 2.

Regards,

Alberto Sabate

Re: top % query

Former Member — Wed, 19 Mar 2008 12:40:01 GMT

I have already do it, but I need the total in query 2 without customer filter

Re: top % query

Former Member — Wed, 19 Mar 2008 12:47:25 GMT

Did you think of using RKF and CFK with some logic?

Re: top % query

Former Member — Wed, 19 Mar 2008 12:56:08 GMT

I'm using RKF and CKF,

I don't know how to extract only the customer that give 50% sales without using condition.

The partial results must be calculate respect to all customer