Calculate label expression

[karensmith]

I am using the below statement for a calculated dimension, I would like to the label to display the calculated monthname or Month/Year from the below expression.

sum

({<FYYear=, FYMonthName=,MonthSequenceNum={$(=only(MonthSequenceNum)-1)}>} POS_Amount, -2, -3, -4.....

I have the additional fields in my calendar table. Any suggestions?

[johnw]

Maybe this?

only({<FYYear=,FYMonthName=,MonthSequenceNum={$(=only(MonthSequenceNum)-1)}>} FYMonthName)

However, since you already have only(MonthSequenceNum), if that is connected to one and only one FYMonthName, I think it might be this easy:

only(FYMonthName)