Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Sort a column and get the top N of the column
Sort a column and get the top N of the column [message #480247] Fri, 14 August 2009 14:32
Evgeny is currently offline EvgenyFriend
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.

Previous Topic:First two pages blank - Data getting displayed from the third page
Next Topic:Count in Chart, TopN
Goto Forum:

Current Time: Tue May 22 10:28:58 GMT 2018

Powered by FUDForum. Page generated in 0.01476 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top