Skip to Content
0
Former Member
Jan 19, 2011 at 12:55 PM

Dependency Calculation between two cross tab

35 Views

Hi,

I have created a webi report with two cross tab.One is having 4 month revenue for a company.Next is showing 4 month net income of accounts in that company.

I need to calculate % of revenue of accounts net income by using sum of revenue.The following are my test case..

Cross tab 1:

Period Nov-10 Oct-10 Sep-10

Account

Revenue 0 50067423.77 56302620.93

Total 0 50067423.77 56302620.93

Cross tab 2:

Period Nov-10 Oct-10 Sep-10

Account

Interest Expense 0 2743826.43 2743826.93

I need,

% rev=(2743826.43/50067423.77)*100 (for Oct-10)

How can I get the sum value of my 1st cross tab?Is it possible in webi?

If Is it so?Please help me....

Regards

Maya