How to set up dynamic monthly counts in "text in chart" field

[#1]

Our client requested the following text on the top of a chart:

Feb 2013 (n=100)  Mar 2013 (n=200)  Apr (n=300) ... up to the last month

I would really like to set that up dynamically like it is possible in a list box by MYear with calculated expression

=' (n='&Count(MYear)&')'

MYear is calculated on the load like

LOAD MonthName(Monthstart(date(DATEFILED))) as MYear

Any help is greatly appreciated

Thank you very much!

[#2]

That's why I wanted to use a text in chart field

[#3]

Can anyone explain me why the following expression works in a chart text field

=MonthName(Min(MYear))&' (n='&Count({<MYear={'Feb 2013'}>} MYear)&')'

but the next (dynamic one) doesn't work

=MonthName(Min(MYear))&' (n='&Count({<MYear={"=$(=MonthName(Min(MYear)))"}>} MYear)&')'

[stigchel]

There is one '=' too many and double quotes should be single

=MonthName(Min(MYear))&' (n='&Count({<MYear={'$(=Month(Min(MYear)))'}>} MYear)&')'

[stigchel]

Oh and I tested something that could work for you as text in chart, used an old qvw with months and sample sizes in them...

=Concat(DISTINCT Maand&' (n='&aggr(sum(if(num(measure)>0,1,0)),Maand)&')',' , ')

[#6]

Very very close!

But months are repeating in alphabetical order, see below:

Under the chart you can see what I'm planning to get.

[Gysbert_Wassenaar]

Are your months the MYear field? If so try creating it as

    date(Monthstart(DATEFIELD),'MMM YYYY') as MYear

And then sort it numerically instead of as text.

[#8 · Accepted solution]

The last post doesn't work, but there is another solution:

to use calculated dimension as

=MYear&' (n='&aggr(Count(MYear),MYear)&')'