Probably an easy one for someone out there. I have a chart that uses a cyclical group as it's dimension (Year / Quarter / Month).
Is there a way of giving this chart a title that changes as the selection on teh cyclical group changes? Eg Expenditure by (Year / Quarter / Month).
It's ok - I figured it out:
='Expenditure by ' & GetCurrentField(TimeDrill)
Retrieving data ...