Display sum of details for the previous year in my crosstab

Ruby

Hello experts,<br />
<br />
i am really stuck in my report design. i have attached a printscreen of my report. <br />
<br />
in the printscreen, at the bottom of my report, i need to display a sum of details (e.g. <strong class='bbc'>Nb Devis</strong>) for the previous year. in this case for the year 2010 for the corresponding origin (<strong class='bbc'>Row area</strong>).<br />
<br />
<br />
can u please give me an idea as to how i could do that? <br />
<br />
Initially, i thought i would create a data set for the previous year and then drag the data in the grid at the bottom. <br />
<br />
However, i also need to take into consideration the origin of my crosstab to show a sum of details only for the corresponding origin.<br />
<br />
<br />
Thanks

mwilliams

So, you don't bring in the data from the previous year? You'll definitely need to do that. You can probably create a crosstab associated with the 2010 data, hide it, store the values needed in persistent global variables and then recall the variables in the appropriate columns.