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