Hi Experts,
In a BI query or workbook,
I need to show TOP 20 customer revenue as indivudual row, the rest of customers revenue are summarized as "Other customers" as single row(Means summation of over TOP 20)... I can use condition to get TOP 20 customer data without problem but no idea for doing "Other customers"?
Thanks and thanks~
MK