Any Ideas on How to Automate Label for Expression?

[#1]

Hi

I have two tables in my query, one for sales transactions containing yymm and salesvalue

I have another table with yymm,month ref and Mmm yy

Because my client is not nt happy with users having pivot tables they currently manual adjust a column in each table every month (Jun 12 is rebuilt as Jun 13)

My expression is sum(if(Month ref = 'x',salesvalue))

What I would have used for my label in other applications would be if(month ref = 'x','Mmm yy'), unfortunately this seems to miserably fail, as does any other formula that I enter in the Label

Any ideas are very much welcomed.

Thanks

[rustyfishbones]

try this

MONTH(MAX(Date) for this month label

MONTH(ADDMONTHS(MAX(Date),-1)) for last month

MONTH(ADDMONTHS(MAX(Date),-2)) for previous month