If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Rank issue

Started by PatrikK, 11 May 2009 07:53:02 AM

Previous topic - Next topic

PatrikK

Hey experts!

I have a report that shows sales on a range of products for current and past month. I want to rank on current month (1-10) and also show what rank the product had past month.

EX.

Product   Sales this month   Rank this month   Sales last month   Rank last month
Apples     22                      1                       17                     2
Bananas   20                      2                       20                     1
...
well you get the idea!

The problem I have is that the ranking for last month only takes into account this month's top-10 products. Pineapples, that sold 17 quantities this month (and ended up as #3), only sold 1 quantity last month ends up as #10 when it in fact really was #22! Crazy!  ;D

Thank you in advance!

Gollapudi

Hi,

You can create two Rank data items for Current month and Previous month which includes expression like    Rank_Curr: Rank(Total([Sales] for [CurrMonth]))
        Rank_Prev: Rank(Total([Sales] for [PrevMonth]))

On top of it, have filter in you Query like Rank_Curr<=10

Thanks,
Gollapudi.