Getting a percentage change

[sthabinash]

I have a row of data as:
Item/Location/TY/LY/Cost/Rtl
I need to develop a report in the format as:
Item1/Location1/TY      / Rtl             /  Cost
                         /LY       / Rtl             / Cost
                         /%Chg /%Chg Rtl /  %Chg  Cost
Item2/Location2/TY      / Rtl             /  Cost
                         /LY       / Rtl            / Cost
                         /%Chg /%Chg Rtl / %Chg  Cost


The %Chg Rtl is calculated as (TyRtl-LyRtl)*100/LyRtl and %Chg Cost is calculated as (TyCost-LyCost)*100/LyCost
I tried this using crosstab space (with fact cells) in a crosstab report. I tried query calculations but wasnot able to get the desired result. I also tried creating metrics but failed. How can I solve this?