Eclipse Community Forums: BIRT » Create RANK column based on Grand Total in Crosstab

Home

Home » Archived » BIRT » Create RANK column based on Grand Total in Crosstab

Create RANK column based on Grand Total in Crosstab [message #1228803]

Tue, 07 January 2014 23:43

Eclipse User

I have a crosstab table with Grand Total (GT) column, which I have sorted by that GT column. I would like to find out the way to show RANK column in the end of the table based on the GT column.

I don't know where to start and already search the internet but can't find the solution the way I want to.

NAME | VALUE A | VALUE B | VALUE C | GT | RANK |
John | 10 | 10 | 10 | 30 | 1 |
Jim | 8 | 10 | 7 | 25 | 2 |
Jane | 10 | 2 | 4 | 16 | 3 |

BTW I am using PostgreSQL as my DB.

I hope someone could help me for the solution. Thank you in advance.

Re: Create RANK column based on Grand Total in Crosstab [message #1229641 is a reply to message #1228803]

Thu, 09 January 2014 17:07

Eclipse User

PostgreSQL docs would be a good place to start.
h t t p ://www.postgresql.org/docs/9.1/static/tutorial-window.html

Previous Topic:	Necessary permissions for BIRT in server.policy file
Next Topic:	class cast exception in extending ReportEventAdapter

Goto Forum:

-=] Back to Top [=-

Current Time: Fri May 16 21:02:30 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter