Dynamic Title based on Column Value

[David Law 2]

I have column value which I would like to use as part of the dynamic title for my cross table.

Take for example the column is a string format with the latest quarter as it's value, ex: Q1-2021

How do I add this value as a property which I can input as part of my dynamic title, so I can get something like: Sales Summary Q1-2021

I assume the script is something like: Sales Summary [MostCommon(["Column Name"])]

[Kirsten Smith (she/her)]

One way would be to create a drop-down property control of the values in your column, then use the name of that property control in the title, like:

 

Scatter Plot of Connect: ${Newchoice}

 

Then it would change when you selected a different value in the property control.