Forum Discussion

ruecj5's avatar
ruecj5
Advocate I
10 years ago
Solved

Format table to read horizontally

I have a report with a line chart that tracks a calculated measure (Satisfaction) over time in monthly intervals (see image).

 

 

I also have the data stored in a way that allows it to be calculated in a quarterly basis instead of a monthly basis and I would like to run a table horizontally underneath the line chart formatted as:

FY15 Q4     FY16 Q1     FY16 Q2     FY16 Q3     FY16 Q4

   119             121              121            120             124

 

But I can only get a table to look like:

 

Is there any way to format this table horizontally as I explained above?

 

Any help is much appreciated,

Chris

 

  • Oof... I feel dumb, it must be late on Friday :smileytongue:  Please disregard this topic.

     

    I just noticed that changing to a Matrix instead of a table allows me to do exactly what I want.

4 Replies

  • nunavut's avatar
    nunavut
    Frequent Visitor

    I also had the same question and wonder how you fixed it using the matrix visuals.  I cannot seem to figure that out.

     

    Kindly advise uisng [email protected]

    • megm001's avatar
      megm001
      Advocate II

      nunavutUnder "Values" in the Format Tab, turn on "Show on rows". That should do it!

  • Oof... I feel dumb, it must be late on Friday :smileytongue:  Please disregard this topic.

     

    I just noticed that changing to a Matrix instead of a table allows me to do exactly what I want.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Can you share how you got it?


      ruecj5 wrote:

      Oof... I feel dumb, it must be late on Friday :smileytongue:  Please disregard this topic.

       

      I just noticed that changing to a Matrix instead of a table allows me to do exactly what I want.