Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Data Set Computed Column problem
Data Set Computed Column problem [message #896509] Wed, 18 July 2012 15:22 Go to next message
Arthur K is currently offline Arthur KFriend
Messages: 1
Registered: July 2012
Junior Member
Hi everyone.

I have a dataset like on the attached picture. I would like to add computed column (yellow one) which will show value for the same account but for previous month. Is it possible at all?

Thanks in advance for any help!

Arthur

index.php/fa/10754/0/
Re: Data Set Computed Column problem [message #896572 is a reply to message #896509] Wed, 18 July 2012 23:59 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Yes this is possible. If you are using 3.7.2 or greater you may want to
look at the crosstab report item with a relative time period aggregation.
http://www.eclipse.org/birt/phoenix/project/notable4.2.php#jump_9

If you using a table you could add a group that is not shown and then
add an aggregation element that aggregates by group. You would not
display this aggregate but you could add to its expression to store it
in prevmonth js var which you would display in the table. If you need
help with this approach post the data in the xls file and I will mock up
a quick example for you.

Jason

On 7/18/2012 11:22 AM, Arthur K wrote:
> Hi everyone.
>
> I have a dataset like on the attached picture. I would like to add computed column (yellow one) which will show value for the same account but for previous month. Is it possible at all?
>
> Thanks in advance for any help!
>
> Arthur
>
>
Previous Topic:BIRT temporary files cleanup
Next Topic:Deploying BIRT application to Geronimo 3.0
Goto Forum:
  


Current Time: Fri Apr 26 02:25:58 GMT 2024

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

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

Back to the top