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 10:32
Evgeny is currently offline 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
Previous Topic:First two pages blank - Data getting displayed from the third page
Next Topic:Count in Chart, TopN
Goto Forum:
  


Current Time: Sat Aug 23 07:37:29 EDT 2014

Powered by FUDForum. Page generated in 0.01709 seconds