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