Margin sheet

[ushaanu]

Hi All,

I have Some Data of revenue and cost actually at present I have done manually for margin calculation .

is there any possibilities for auto calculation.

sample file enclosed.

Thanks in advance

Regards
Anu

 

[Nebu]

Hi:

If you are using excel 2010 or above use the power pivot to connect the two data sets and calculate the margins in the pivot itself.

Thanks