Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Data Set Computed Column problem
Data Set Computed Column problem [message #896509] Wed, 18 July 2012 11:22 Go to next message
Arthur K is currently offline Arthur K
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 19:59 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
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: Tue Jul 22 05:19:15 EDT 2014

Powered by FUDForum. Page generated in 0.02601 seconds