Custom Total or Conditional Total Column

[#1]

Hi,

I have the below business requirements, hope you can help me with this.

I have attached the excel file as well in case you would like to do some testing.

Thanks and hope to hear from you.

~skip

[Anonymous]

See the attached.