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
