|Sort a column and get the top N of the column [message #480247]
||Fri, 14 August 2009 10:32
Registered: July 2009
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:
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.
Powered by FUDForum
. Page generated in 0.01709 seconds