top % query

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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