subtraction and division in pivot table

[arulsettu]

Hi,

     I am trying to do profit and loss statment. here in pivot doing row wise calculation using flags. my issue is when i try to subtract two rows i am getting same value for every rows. and for division also. when select particular lob it showing correct vale.

please check the sample app and suggest some idea. i am really stuck here

[arulsettu]

the ABOVE method is it. its giving same result like i said before. i thim i am doing some mistake can i upload my app so u can ckeck the mistake

Thanks

[arulsettu]

Thank you very very much it works.

one more doubt how to show the values negative to positive and positive to negative

Thanks