Please Find the Attached Excel need Report in some Different Format

[abhaysingh]

Hi All,

       i want the report in below format

Output
Name	Current Year	Last Year	Current Year Last Month     Last Year same month as shown in left column
Revenue
Cost
Gross Margin
Gross Margin%
Depreciation
Amortization
EBIT
EBIT%

where Gross Margin = Revenue+Cost

Gain MArgin % = (Revenue+Cost)/Revenue

EBIT= Revenue+Cost - Depreciation - Amortization

Ebit% =(Revenue+Cost - Depreciation - Amortization)/Revenue

in my Field only dimension value exist are Revenue,Cost,Depreciation,Amortization.. and rest are calculative value

regards

Abhay