Remove wrong legend

[Anonymous]

Hi community,

I have dimension

=MYear&' (n='&aggr(Count([qID_10395_Purpose of visit MARKETING]),MYear)&')'

and in result

How can I remove (n=1)?

It works where I use only MYear without aggregation.

Thanks,

[swuehl · Accepted solution]

Maybe like

=MYear& if(MYear,' (n='&aggr(Count([qID_10395_Purpose of visit MARKETING]),MYear)&')')

[Anonymous]

Thank you!!!!!