Hi,
I have a requirement to show the top 6 loss accounts for 2009 over 2008 and remaining all accounts should be displayed in a single row as ALL-OTEHRS,
I Created a query selected 2009 and 2008 years in to the report, created 2 variable one is for 2009 and the other one is for 2008 year then caluclated the difference . now i want to calculate the rank on difference and show top 6 loss and all other accounts displayed as single row , Can you please advise me how to get this done,
( I tried creating a rank function on diff year for example rank(diff year;acct_name) when i drag this i am getting the context though i added all dimensions in to the rank variable,
Thanks In Advance
manjub (BOB member since 2008-10-17)
(BOB member since 2009-08-03)