Reporting need : showing min,max & diff of first row total with others

52 Views

Hello ,

I have 2 reporting needs , in which report layout required

is as below.

Wk1 Wk2 Wk3 Wk4 Total Diff

Wk1 1 2 4 2 9 0

Wk2 _ 3 2 1 6 -3

Wk3 _ _ 2 2 4 -5

Min 1 2 2 1

Max 1 3 4 2

Problem i have is in showing the difference. Total comes automatic.

How can i compute difference with respect to first row.

For Min & Max , when i create a formula, and set its Calculate Result as

property to be min/max,

I get the min /max value at the bottom. But then the values in data rows repeat like

Wk1 Wk2 Wk3 Wk4 Total Diff

Min 1 2 4 2 9 0

Max 1 2 4 2 9 0

Min _ 3 2 1 6 -3

Max _ 3 2 1 6 -3

Min _ _ 2 2 4 -5

Max _ _ 2 2 4 -5

Min 1 2 2 1

Max 1 3 4 2

This i don't want. I want a single row for min & max. How can i do it.

Thanks for your help as soon as possible.

PS.. I have put this '_' to show that value is blank in this field.. which is fine