Hi I am new in this and i would like to ask how to produce annual Growth rate using crosstab? to make it simple ,in my database it contains the Year, Item,quantity like this: YEARITEMQUANTITY2014Book 352014Pencil562015Book672015Pencil50 now in my report query i filtered it by "YEAR". By creating crosstab i produced something like this: $F{Year}Total Quantity Measure$F{Item}$V{Quantity_measure}$V{Quantity_measure} which shows something like this 20142015TotalBook3567102Pencil5650106 I want to calculate the annual growth rate but cant manipulate the datas by Year as it only produces the total of both years, is there any way i can use the formula for annual growth rate in crosstab? Can anyone give me a sample template or any info on how to do it? Thank you very much. I want to produce a report output like this: 20142015Growth RateBook356791.42%Pencil5650-10.71%
