Condition for Excluding Top N values

[Former Member]

HI,

I have a requirement wherein..The Total value of Customers Excluding Top 15 needs to be displayed

Does some one have idea on how to define this condition?

Thanks in advance

Sriman

[former_member205352]

In the query designer

Go to Conditions button and click

A new tab will open, right click and say new condition.

Choose you key figure and TOPN and for value choose 15.

Also tick Customers only in the top tab.

Hope this helps.

[Former Member]

Hi,

Well,its quite straightforward if the requirement is for Top 15 Customers!!

But What I want is the result of all the Customers Excluding Top 15

Hope it is clear now

Thanks

[Former Member]

there is a workaround..

if that is feasible for ur users

lets say u have 100 customers, so

excluding top 15 = including bottom 85

but its not true that u will have 100 customers ,

so instead the work around is use %, instead of exact values = 15

try to use condition on Keyfigure

Select new condition

select keyfigure

select BOTTOM %

value = 85

if that is

[Former Member]

HI Kartikey,

Thank you.

But the problem is :

Lets say at one time they have 100 customers..then including bottom 85% works perfect as it is like excluding Top 15 .But at some other point in time they have 200 Customers,then with the same condition it excludes Top 30 customers.

Getting the result from 16th Customer is the main criteria that I am looking for

[Former Member]

yes sir

that is true...thats why i did comment that all the time you will not have 100 customers.

as far as i know there is no real way to do that.

it might require some coding and couple of tricks in transformation routine, if that really works out...

[former_member205352]

I am not sure but will RRI query work ???

You can have sender query with Condition TOP15.

Use all the customers of this query and exclude it in receiver query, which is same a sender query but without condition TOP15.

Just an idea never tried this.