Top 11 instead of Top 10

[Former Member]

Hello!

I have a Report with the following objekts in report:

Part No.

Dealer

Sales

I have a Top N condition on Part No. depends on Key Figure Sales. But sometimes I have 11 values and Top 11. This 11. value is indeed the 152. value.

If I take Dealer out it works fine. If I select another time frame it works also fine.

Does someone know this problem and can help?

Best regards,

Peter

[Former Member]

HI Peter,

Check if any of the two dealers have the same rankings.

[Former Member]

Hey!

If you think, that I have two times the same dealer in my top 10, that is possible. I have this dealer which is 11 and two times this dealer for position 2 and 3. The ranking is on Part No. so I think this should be no problem because every part No. could be just from one dealer and this would be ok.

My report could look similar like follows:

Part No. - Dealer - Sales - No.

153254 0001 599.00 1

156486 0024 486.45 2

245686 0001 435.84 3

... ... ... .

123545 0048 125.52 10

251564 0001 12.56 11

And the 11. is the one which shouldn't be there because of the condition.

Regards,

Peter

[Former Member]

Hi,

so what's the relevant condition:

the Part-No only or the Part-No/Dealer-Combination?

what i mean: is the condition on Part-No only or an all characteristics?

do you have only on sales Volume or is there another KeyFigure in your condition (both then are connected by "OR").

Cheers

Sven

[Former Member]

Hi!

I tested both Part No and combination and over all characteristics.

In my query I have additional key figures but they are not relevant for this problem. They are not in the condition.

Thanks for asking.

Best Regards,

Peter