1 Reply Latest reply on Mar 24, 2017 12:11 PM by Sara Sparks

    Displaying column names as Rows

    Suresh Reddy

      Hi All,

       

      I have a simple report as shown below.

       

      I want to display the above results as below on the worksheet.

      Its looks like a simple one but I could not able to figure out .

      Could any one please help me on this.

      Thanks in Advance.

       

       

      Thanks,

      Suresh.

        • 1. Re: Displaying column names as Rows
          Sara Sparks

          Hi Suresh!

           

          There is a way to create this kind of report, but it isn't as robust as you would hope. It works alright if you are only looking at displaying one "row" of data (i.e. one customer), but it gets muddled when you need to display multiple records.

           

          We can put a unique field (like "Customer ID") on the Rows shelf, and then add the fields we want to display as text on the Marks Card. In order to display "Headers" (like "Customer ID", "Customer Name" and "Country") we need to create a second sheet, using the same method as the first. We can then place both sheets on a dashboard, to get an approximation of the stacked style. Unfortunately, if these need to scroll, the sheets will do so independently, which is why it doesn't work as well for multiple records.

           

          I've attached the workbook, which uses the proposed solution. Hope this helps!

           

          Sara

          1 of 1 people found this helpful