How to use expression to replace my 12 expression ?

[paulyeo11]

Hi All

My below expression working fine :-

=money(fabs(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-12),'YY MMM'))"}, month = ,year=>}[Amount]/1000/$(Columndim89)))

, $(vCurrencyFormatK))

I need to use 12 expression for display  12 column data. Table (A) refer to enclosed Table .

My question it is possible to replace one expression instead of 12 expression ?

Paul

[calvindk]

You could try and make it into a pivot, and use monthyear as extra dimension (pull it to top).

Then you should be able to reduce it to one expression, although i dont have time to sort out the expression right now.

Best wishes

[paulyeo11]

Hi Andres

Many thank to response on my post. Yes I manage to get it work base on yr proposal. But now I need at once more diamension on balance sheet field that is GL DESC. can you share with me how ?