Automatic Title Change?

[MuraliPrasath]

Hi,

I've a show conditions buttons for pivot table.but based on the user's selection my title needs be shown.

For example:  If the user selected the  MML and RXV then title needs to show MML & RXV together.

[Chanty4u]

Hi ,

Create an html file and give that link path in actions..

hope this helps you

Thank you

Suresh

[Anders_Eriksson]

Don't see a problem here?

I guess your buttons sets variables that you use in show conditions for the expressions in the table.

Use calculated titles and the same variables and it should be easy.

[Anonymous]

can you post your title of your Pivot table

how to you Combine the button into title?

[jagan]

Hi,

Give this below expression in Title

=vMML & ' & ' & vRXV & ' & ' & vICL & ' & ' & vBBB & ' & ' & vTotal

Replace vMML, vRXV, vICL, vBBB and vTotal with your actual variable names.

Hope this helps you.

Regards,

Jagan.

[MuraliPrasath]

Hi Jagan,

Here is my title code.

=vShowMML & ' & ' & vShowRXV & ' & ' & vShowICL & ' & ' & vShowBBB & ' & ' & vShowTotal

but the title output shows like this now. 

1 & 0 & 0 & 0 & 0

[jagan · Accepted solution]

Hi,

Instead of setting 1 & 0 you can set MML & blank space, RXV & blank space etc.  If you attach sample file then it would be easier to understand.

Regards,

Jagan.

[Anders_Eriksson]

This will do it;

= Replace(Replace(if(vShowMML, 'MML§') & if(vShowRXV, '§RXV§') & if(vShowICL, '§ICL§') & if(vShowBBB, '§BBB§') & if(vShowTotal, '§Total'), '§§', ' & '), '§', '') & ' Schedule'

[MuraliPrasath]

thanks Jagan.

Finally I'm using the below one to show the selected button title on Pivot table..

=if(vShowMML,'MML')&'  '& if(vShowRXV,'RXV') &'  '& if(vShowICL,'ICL') &'  '& if(vShowBBB,'BBB') &'  '& if(vShowTotal,'Total')

[jagan]

Good, you catched the logic.

Regards,

Jagan.