How to Add Max and Min Value from different row.

[former_member593850]

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?

[Tom_N8 · Accepted solution]

Hi Ayush,
After you have executed your query in WebI you simply create a new variable with the formula
=(Min([Col C])+Max([Col C])) ForAll([Col B])
Replace Col C with your variable, then right-click Col B and select Hide > Hide Column. Voila!

Kind regards,
Tom