1 Reply Latest reply on May 22, 2012 10:13 AM by Tracy Rodgers

    Formatting Data Shown In Table

      I will try my best to describe my problem and I may be overcomplicating it.  I have a data set with columns that contain scores pertaining to each Customer ID in a row.  So you have Customer ID with CP SCORE in one column, TECH SCORE in another etc.

       

      I want to be able to create a table that formats the column heading as a ROW with the groups associated within that, stacked on top of one another:

       

                            GROUP 1

      CP SCORE     GROUP 2

                            GROUP 3

       

                            GROUP 1

      TECH SCORE GROUP 2

                            GROUP 3

       

      As opposed to it trying to format like this:

       

      CP SCORE  TECH SCORE GROUP 1

       

      Does this make sense?

        • 1. Re: Formatting Data Shown In Table
          Tracy Rodgers

          Hi Alyson,

           

          It sounds like CP SCORE and TECH SCORE are two different fields. If this is the case, I would recommend either reshaping the data so that they are in the same field or creating two worksheets (one with CP SCORE and one with TECH SCORE) and placing them on a dashboard together. Hope this helps a bit!

           

          -Tracy