I'm not sure which video it is, I went back and looked through a few, but couldn't find it.
Anyways, the titles of the worksheet will either show or won't. However, I did have a thought--though depending on the names of the worksheets it may not be plausible. Show a text dashboard object on the dashboard and use the Insert button to place the Parameters inside. Then, change the member names of the parameter to reflect the names of the title?
Just an idea! Hope it helps!
Another option is to create a separate worksheet that has a calculated field for the desired title and formatted to look like a title, and use the same filtering to show/hide that worksheet.
I have two sheets ( out of a total of ten sheets ) that need be displayed when I click the do the "select a sheet" filter and I was hoping to achieve this by moving one of the sheets to the title/caption section of the other sheet that also needs to be displayed. But to accomplish this, I need the worksheet titles to appear and disappear with the rest of the data. Were you, by any chance, able to locate the video that Matthew is talking about in his post?