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]

you are right

Clockwise Calculation = c, do sum({<TD_DRCR_FLAG={'D'}>}TD_AMT_LC_1)-sum({<TD_DRCR_FLAG={'C'}>}TD_AMT_LC_1) do the calcuation based on the ClockwiseStart and Clockwiseend.

[arulsettu]

i stored it in a variable and used but getting same value for every colunm. can please tell me how to do it?

very emergency

Thanks

[sunny_talwar]

On my way to work... Will work on it once ai reach there.

Best,

Sunny

[arulsettu]

Thak you verymuch. waiting for your help. if you need any data please let me know

[sunny_talwar]

Arul can you please create an excel file with the output your hoping to see? Otherwise I am having a hard time understanding what you need here.

[arulsettu]

please look this excel is enough

[sunny_talwar]

Arul I am trying to help you man, but I don't understand your data. Your output you are expecting is totally different then the file you sent me. I am not sure what I need to fix and where I need to fix . Either reduce some data in the app or make some selections or do something which makes it easy for me to understand what you are looking for.

Sorry for not being very helpful.

[arulsettu]

ok no prob i will upload app

[sunny_talwar]

Checking now

[arulsettu]

sunny take your time if it is possible tomorrow it would be very helpful. and if u need anything please let me know..