5 of 5 people found this helpful
Not sure this can be done with the standard dashboard title object (without using fancy parameters but that's a pain)
However, rather than adding a Title object, you can add a blank worksheet and have that appear to be the dashboard title instead. See the attached for an example...
Hope that helps...
Thank you for taking a look. However, I tried to create a blank worksheet and place the necessary filter on the new worksheet, but when i added the worksheet to the dashboard it shows blank worksheet.
Can you write out the steps of how you were able to do that?
Nevermind...I figured it out!!! Thank you very much for your help and your suggestions.
4 of 4 people found this helpful
In your blank worksheet, add something to level of detail... SUM(Sales) or something like that... anything will do.... This just tells the worksheet to connect to your data set but doesn't draw anything.
Then in the dashboard, double click the blank worksheet's title and edit the text to include the fields which you want to display in the dashboard - adding them from the drop-down is the easiest way.
To do the To and From dates, I had to create some calculated fields in the data source - just min(Date) and max(Date). I added these to the level of detail in the worksheet so that they were available to the worksheet in the title.
Remember to set your filters up so that they apply to the blank sheet (or apply to the whole data source)
This is helpful. I just want to confirm is this possible to do in the text boxes.
Suppose if I want to add a text box and want to add the filter value in it.
Is it possible?
2 of 3 people found this helpful
No, I do not believe you can. When using the 'insert' option with a standard text box, the only parameters available in the drop down context menu will be basic, system ones such as the workbook's name, the sheet's name, the user's name, or any parameter values. But as it stands now, you could not use a text box to dynamically title things using filters from other worksheets.
Can you tell me how you get all the filter selections to show? If multiple values are selected the dynamic title will show the first few selections and then say "and 2 more" or "and 3 more" instead of the other filter selections.