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?