Sort a column and get the top N of the column [message #480247] |
Fri, 14 August 2009 14:32 |
Evgeny Messages: 19 Registered: July 2009 |
Junior Member |
|
|
Hello and thank you for reading this post,
I am new to Birt and have just started building a report.
My goal is to display topN customers in descending order. And my table is
looking like this:
Customer A
Customer B
Customer A
Customer A
Customer C
Customer C
Customer A
What I succeeded so far is to create a report which shows me the amount of
the orders of the customers, it looks like this:
Customer A - 4
Customer B - 1
Customer C - 2
I have done that by having a Count function in the Summary Field of the
Data Cube and a Sum function in the field on the Cross Tab.
And here my problem:
I would like to sort this table in descending order. And then get the top
N customers (customers with the most orders). I have seen in some
tutorials that there is normally a "Sorting" Tab in the Property Editor,
but I there is no such tab in my eclipse (though I just downloaded the
last 2.5 version of Birt).
Any help is greatly appreciated.
Evgeny
|
|
|
Powered by
FUDForum. Page generated in 0.02700 seconds