Calculating Ratio Row over column and vice versa
Hi Experts,
We have a requirement to calculate percentage of Row over Column and vice versa, does any one have done any work in the regards?
E.g. In Income Statement we have columns like Div1 Div 2 Div 3 ... Total
and Rows - Revenue
Cost of Revenue
GP
We want to define row
% Div of Revenue over Total revenue
% Div GP over Total GP
Similarly in Column we want to define extra column with % Exp over Total Revenue
Please give guidance.
Regards
Sanjiv