Hi all,
I want to show top 10 Mangers in a table and below that i want to show. rest of the mangers.The main problem is i want to show them separtely.
Is it possible.
vvemula (BOB member since 2008-07-02)
Which database are you on? Also, based on what criteria do you determine the top managers? It is possible, you will need to provide more details though.
nithya_raj (BOB member since 2007-02-03)
Apply Rank() that will display TOP 10 Managers. Now Insert one more Row below and Put NoFilter(Sum([Measure]))-Sum([Measure]).
This will display the SUM of other then TOP 10 managers.
Rakesh_K 
(BOB member since 2007-12-11)