Expression in Title

[gerhardl]

Hi,

Can I put an expression in the Title of a chart?

I have a chart called "Performing Customers for the Month". I would like it to say "Performing Customers for April", with the month name being determined by the expression.

This is the expression I use to determine the number of performing customers, so I could use the variable to determine the "current" month (which is just the maximum month).

COUNT({1<[Effective Year]={$(=($(vCurrentYearPurchase)))},[Effective Month]={$(=($(vCurrentMonthNamePurchase)))},[Tran Code]*={35}>} [Effective Date])

Thanks,

G

[#2]

Hi

In Window title

Put in

=COUNT({1<[Effective Year]={$(=($(vCurrentYearPurchase)))},[Effective Month]={$(=($(vCurrentMonthNamePurchase)))},[Tran Code]*={35}>} [Effective Date])

Regards

Anders

[gerhardl]

Hi Anders,

I am using =Month($(vCurrentMonthPurchase)) and that works fine, but it just gives me the monththen - April.

I would like the title to be "Performing customers for April", so it must be normal text, and then the expression value.

Possible?

Thanks,

G

[#4 · Accepted solution]

Hi

Use

='Performing customers for ' & Month($(vCurrentMonthPurchase))

Regards

Anders