3 Replies Latest reply on Jul 12, 2016 6:02 PM by Nicholas Gorman

    Displaying Text Table for Most Recent Week and W/W Change

    Nicholas Gorman

      Hi Everyone,

       

      I need some help making a text-table like this one:

       

       

           

      Westpac St. GeorgeBank of MelbourneBank SABTBT Adviser ViewTotalWoW Change %
      This weekWoW Change %This weekWoW Change %This weekWoW Change %This weekWoW Change %This weekWoW Change %This weekWoW Change %
      Online Form Complete % % % % % % %
      Phone calls % % % % % % %
      Total Leads % % % % % % %
      Referred to Face to Face Advice % % % % % % %

      I know that one solution would be to make many different sheets and put them all in one dashboard, but I was wondering if there was a quicker way to build this view onto one sheet.

       

      The data is formatted like this:

       

         

      MeasureWeek endingOnline appointment form enquiryInbound phone enquiryTotal enquiriesTotal ActivityNon-ContactNon-qualityIn progressReferred to Face-to-Face AdviceReferred to Phone-based AdviceReferred to Scaled Advice (limited)Referred to Scaled Advice (BTAC)Referred to Scaled Advice (Super)
      BT 2/10/2015nnnnnnnnnnnn
      BT Adviser View2/10/2015nnnnnnnnnnnn
      WFP 2/10/2015nnnnnnnnnnnn
      SGFP 2/10/2015nnnnnnnnnnnn
      Get moving2/10/2015nnnnnnnnnnnn
      Total2/10/2015nnnnnnnnnnnn
      BT 9/10/2015nnnnnnnnnnnn
      BT Adviser View9/10/2015nnnnnnnnnnnn
      WFP 9/10/2015nnnnnnnnnnnn
      SGFP 9/10/2015nnnnnnnnnnn

      n

       

          with digits where the n's are, and many more weeks going further down the page.

       

      The problem I am having is getting both the W/W view and the most recent week view on the same sheet.

       

      Please let me know if you can help.

       

      Thanks,

       

      Nick