1 Reply Latest reply on Jun 21, 2016 9:00 AM by bill.cunningham

    Using a worksheet several times on a dashboard as captions

    Ben Bonekyn



      I have had a request to add dynamic captions to a dashboard based on the quick filter (call these products) that is selected. The dashboard contains several worksheets and the users would like to have a caption for each so that they can describe what they see on each worksheet for the product that is selected.


      The only way I can think to do this is to create separate sheets for each worksheet that will act as the reciprocal Comment for that worksheet. This seems very messy.


      Is there a way I can create one worksheet and use it several times on the same dashboard to fulfil this function?


      Many thanks,


      My data looks like this:


      And the dashboard looks something like this: