how to show value rank>5 in cognos report studio

[inu]

Hi Team,
Please find the mockup and tabular data attached
                                                                                                             

Occupation Description column contains
case when rank=1 then 'Occupation 1'
when  rank=2 then 'Occupation 2'
...
else 'Others'
end

[AnalyticsWithJay]

Hi,

I'm not sure if I understand your question. Are you trying to get the total for all occupations not within the top 5? If so:

total([disbursement amount] for [occupation description])

[sdf]

are you trying to show the same data from the list above to the tabular data below?
Have you tried using a cross tab?