1 Reply Latest reply on Nov 5, 2018 3:14 PM by Jennifer VonHagel

    Dynamic Title based on Multi Select Filter

    Ann Engel

      I have an Excel spreadsheet that is used for a daily report out, that includes data for date, current month, and YTD.  The goal is to end the year at 97% or higher, so tracking percentage is important to report on.

       

      How do I go about adding the percentage data in the worksheet/dashboard I have created...or is there a better way to show this? 

       

      Thanks in advance!

        • 1. Re: Dynamic Title based on Multi Select Filter
          Jennifer VonHagel

          Hi Ann,

           

          It would be helpful if you could attach a .twbx workbook so we have a better idea of how your views are set up.  From your screenshot, it looks like you can add your measure to the table a second time, click the right dropdown box on the second measure pill, and do a Quick Table Calculation for % of Total, Compute Using > Table down.

           

          Hope this helps,

          Jennifer