I have gotten it to do this by creating another worksheet with the data parameter as the title of that particular worksheet. Then I put that worksheet at the top of my dashboard. It isn't the fanciest, but it gets it done.
Thank you Tom... but i don't know why caption of title sheet just below and horizontal to title is not coming in dashboard.
Message was edited by: Ranjan Sahoo
1 of 1 people found this helpful
I've approached this in two different ways:
I've created a separate worksheet that will act as the title/header for my dashboard. Once created it will be in your list of available sheets for your dashboard. Place the date information where it's most convenient. I've used both the text shelf (with hidden row and column headers) and the title, making sure that all the fields I need appear at the very least on the Level of Detail area.
A second way is to add the date field to the title of the main (most prominent) worksheet included in your dashboard. The field/calculation must be somewhere in the viz; I use the Level of Detail shelf if it isn't already used in your viz. Then you can Insert that element from the Title edit window.
hope this is useful,
Thank you Astrid Henriksen and Tom ,
Second option was ruled out as 4 sheets will occupy the top row in dasboard.
First option is good, actually caption was not visible, that was my issue.