calculation on crosstab

[jcie]

Hi,
Sorry for my poor english. I hope you will understand my problem.

I ve got a crosstab like that :
product1 product2...........
yearN | yearN-1
commercial1
commercial2
........

And I would like to create a new column with the % of growth between yearN and yearN-1. It seems to be very easy but i can't make such report.
Ive tried with advanced caclculation but it doesn't match.
Is there someone to help me.
Thanks

 

[DoubleD]

I'm not sure if it can be done in ReportNet, but Impromptu is not designed to function in this way. However, there is a workaround.

Assuming you only want a defined number of years:
Create a calculated column for each year.
YearN:
If(Year(DateField) = Year(Today())) Then (Value) Else (0)
YearN-1:
If(Year(DateField) = Year(Today())-1) Then (Value) Else (0)
etc.

Now create a third calculation:
(YearN - YearN-1)/YearN-1

Put all three calculations in your crosstab.

I am what I am based on the decisions I have made.

DoubleD