The TOTAL default column for measure is 0 when...

[#1]

....I use IF statements in the calculation. In my case I have month on rows and I do calculation for actual month and two month ahead. the rest of the month is 0. BUT I would like to have the TOTAL sum for the three months I have.

if ( trim([Kalender månad]) = trim(TodayOne) Sum (Budget)*0.10,
if ( trim([Kalender månad]) = trim(TodayTwo) ,Sum (Budget)*0.25,
if ( trim([Kalender månad]) = trim(TodayThree) ,Sum (Budget)*0.50,0)))

regards mikael

[johnw]

Perhaps this?

sum(aggr(
if ( trim([Kalender månad]) = trim(TodayOne) ,Sum (Budget)*0.10,
if ( trim([Kalender månad]) = trim(TodayTwo) ,Sum (Budget)*0.25,
if ( trim([Kalender månad]) = trim(TodayThree),Sum (Budget)*0.50,0))),[Kalender månad]))