Read Column value from table

[sush]

Hi,

I have a table which has 2 columns (Year Amount, Life Amount). These 2 are calculated columns based on the formula in Set Analysis.

Now I want to add the third column - Amount which shows either Year Amount or Life Amount based on Criteria. Could you please let me know how can we achieve this?

Thanks

[Kushal_Chawda]

You may need to use it in your measure

=sum({<FYMActDate.YearMonth={">=$(=date(addmonths(max(FYMActDate.YearMonth),-5),'YYYY-MMM'))<=$(=date(max(FYMActDate.YearMonth),'YYYY-MMM'))"}>}Amount)

[sush]

I tried as Measure, its all coming as 0's 

[Kushal_Chawda]

Can you share a sample where you are trying?

[sush]

Please refer attached sample file

[Kushal_Chawda]

see the attached

[sush]

I am sorry for the delay in responding to this. I got into something before I check this out. I will try this and keep you posted. Thanks a lot for looking into this.