3 Replies Latest reply on Apr 29, 2016 1:10 PM by christina.lahti.0

    How do I place percentage of difference in a text table row?

    christina.lahti.0

      Greetings all,

       

      I am trying to display the percentage of difference (via quick table calculation) on a 3rd row. I have read through a few that suggested creating the percentage difference on a second sheet, then removing the headers and placing it as I've done in the dashboard example below. However, I've been unable to get the columns to line up and it looks terrible.

       

      Does anyone have a recommendation on a better way to do this?

       

      Dashboard example:

       

      I am unable to share the workbook due to client confidentiality issues, but this is done through a direct connection to Google Analytics if it helps any.

       

      My worksheet MoM Comparison worksheet

       

      My Percentage difference worksheet

       

       

      Thank you kindly for any advice.

       

      - Christina