COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Sree99 on 23 Jun 2020 12:43:25 PM

Title: Row Level Calculations- Cross Tab
Post by: Sree99 on 23 Jun 2020 12:43:25 PM
Hi all

i am trying to calculate as below.

the calculation will be as follows in cross tab.

Revenue                                                             100
Direct Labor                                                          50
Direct Expenses                                                    10
Total Expenses (Direct Labor+ Direct Expenses)       60
Gross Profit      (Revenue - Total Expenses)             40
%                   ( Gross Profit /Revenue)              0.4%

how do i do the calculations in the cross tab. i am having trouble calculating this.

help on this is greatly appreciated.

Thank you in Advance

Sree