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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Wed, 08 January 2014 04:43

Yuswardy NA

Messages: 3
Registered: December 2013

Junior Member

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.

Report message to a moderator