Bring value from one or another column and then sum the exact values

[clovati]

Region	Col1	Col2	Col3
REGION1	100	200	100
REGION2	100	50	50
TOTAL (sum)	200	250	150

Hi all.

Col3 >>>> if Col1<=Col2 then Col1 else Col2

How can I have the TOTAL (SUM) in Col3 = 150?

By default IF is applied also to totals and then I obtain 200 as Total in col3.

Thank you ALL

[arulsettu]

is this you want

[antoniotiman]

Hi Cristina,

try

Sum(Aggr(RangeMin(Col1,Col2),Region))

Regards,

Antonio

[arulsettu]

if yes write expression like this

if(Column(1)<Column(2),Column(1),Column(2))

and change the total mode

[clovati]

It's a pivot and TOTAL MODE are disabled

[clovati]

Region is in drill ... how can I do it when I drill down ?

thx

[MK_QSL]

Considering your expression as below

Column1 = SUM(Sales1)

Column2 = SUM(Sales2)

You can write as below

SUM(Aggr(IF(SUM(Sales1) <= SUM(Sales2), SUM(Sales1), SUM(Sales2)),Region))

[arulsettu]

what other fields are in the drill down. can you post sample data

[Anil_Babu_Samineni]

I am sorry if i miss something to read. Please use SUM for over expression if it is in Pivot

Sum(If(Col1<Col2, Col1, Col2))

[MK_QSL]

For Drill down group use as below

SUM(Aggr(IF(SUM(Sales1) <= SUM(Sales2), SUM(Sales1), SUM(Sales2)),$(=GetCurrentField([New Group]))))

Where [New Group] is your drill down group name