Ranking to be applied over the aggregation

[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