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

      Hi,

       

      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,
      Ben

       

      My data looks like this:

       

      And the dashboard looks something like this: