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

Ranking to be applied over the aggregation

Started by Jansi, 07 Jul 2011 11:55:53 AM

Previous topic - Next topic

Jansi

Hi,

In one report I have a block which has the following columns.

Rank    Flag   Channel   Sub_Channel       Clarifier     Customer      Current_year_revenue Sales%Mix
1          I         A              AA                         AB             XXX                     300                       300/600

2            I         A              AA                         AB             XXY                      200                       200/600 

3            I         A              AA                         AB             XYZ                      100                        100/600
                                                                                                    Total   600

i.e. When this grouping has many records, I have applied ranking and filtering and filtered the first 3 records based on the revenue. Sales%Mix column has to consider rev/total(rank enabled rev) for each clarifer, where as now it skips the filter based on ranking in the field total(rev)

Can someone please guide me to achieve the aggregation over the ranked & filtered records?

Thanks in advance,
Jansi