Format table to read horizontally

[ruecj5]

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

[nunavut]

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 lcgalaxy@gmail.com. 

[megm001]

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

[ruecj5 · Accepted solution]

Oof... I feel dumb, it must be late on Friday   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]

Can you share how you got it?

---

@ruecj5 wrote:

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

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

---