How to Add Max and Min Value from different row.

Hi All,

I am creating webi report, where my Source data is

And I want to display it as (Where Column highlighted will not display actually). I dont know how to calculate value for "Column C"

Can someone please help me in this?