Skip to Content
0
Former Member
Feb 23, 2010 at 03:07 AM

BI(7.0) Query Condition Problem

21 Views

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