Mutliple Filter Values NOT Displaying in Dynamic Title

[#1]

Hi there,

I am familiar with creating a Chart Title that contains a filter (variable) value that will dynamically change the title to include the Filter value.

How do I display the values of the filter if there is more than one filter value selected though?  Using the standard method, the filter values don't display at all in the title when there are multiple filter values selected. It works fine though when only one filter value is selected.

For example:

Filter Box: FinancialYear

• 2011
• 2012
• 2013

Chart Title: ='This is the Financial Report for: ' & FinancialYear

If I select 2011 (or 2012 or 2013) then the Chart Title looks fine as: This is the Financial Report for: 2011

If however, I select 2011 and 2012, then the Chart Title looks like this: This is the Financial Report for:

How can I display both 2011 and 2012 when they are both selected?

I know someone out there can help, and I thank you in advance!

[#2 · Accepted solution]

Hi Rene,

you may use expression like this:

=' This is the Financial Report for: '&Concat(F_year,',',F_year)

You my also use GetFieldSelections()...

I prepared example:)

[#3]

Thank you SO MUCH Darius!

It works like a charm, using get GetFieldSelections()

I really should have thought of that!

... And the Concat works even better! Especially when you have an OnActivate Sheet trigger. In such a case, the Concat gives a cleaner result in the title.

Thanks again!!

[#4]

Hi all,

This may be of use to someone (hoping)

I have also now found GetFieldSelections(FinancialYear) which alleviates duplicates that can occur when using Concat.

GetCurrentSelections might give too much information in some cases.