nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

year vs year-1 comparison in birt cross tab

kumbare

Hi,
 
I have created simple Cross tab report which will display sales data for each year for client.
 
consider attached example. I want to add comparison between a year with its previous year.
 
could you please provide some example or link which can help me to achive it.
 
Thank you in advance.

Find more posts tagged with

Comments

Clement Wong

Depending on your data source, it might be best to return the data in that format with those comparisons. Otherwise, you will need to code your report design to make those calculations.
 
With scripting, you will have a few options.
 
Option 1: Make a copy of the original table to a global array, and then use a scripted data source to perform the calculations. Then, use the scripted data source for your table.
 
Option 2: The end result of this looks slightly different that your screenshot, but essential has the same new columns. The attached example design was created in commercial BIRT iHub 3.1. Note the only difference between OS and commercial BIRT here is the use of the Static Data Source to quickly mimic your data without comparisons [Client, Years 2010-2012 and their values]). 
 
Create a computed column in your existing Data Set to save off the previous value. Initialize the variables in beforeOpen of the Data Set.
 
Create a Data Cube and include a new measure using that newly created previous value computed column. Then, create a Cross Tab using the Data Cube.

kumbare

Thank you for your quick reply but i am not able to run this report in eclipse it is showing one error.
 
 
Could you please provide me rpt file in eclipse ?
 
Is it possible to do it using "Relative Time Period" option ?

Clement Wong

Yes, it is possible as I see that Pierre answered the same question in the <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/35769-year-by-year-comparism/?p=137942'>other thread</a>. I forgot that in BIRT 4.2, we added <a data-ipb='nomediaparse' href='http://www.eclipse.org/birt/phoenix/project/notable4.2.php#jump_9'>Relative Time Period for Crosstabs</a>.
 
Again, by using Relative Time Period, the output (location of the previous year comparison) will look similar to my screenshot versus your first post's mockup.