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
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])
are you trying to show the same data from the list above to the tabular data below?
Have you tried using a cross tab?