1 Reply Latest reply: Mar 16, 2016 11:48 AM by Andrew Whitfield RSS

    Hiding label column in a pivot table? Or switching the axes/transposing a straight table?

    Loren Dean-Austin

      Hi there,

       

      I am trying to present data (that has been calculated in the script) as tables. Each of the fields shown in the tables below have been calculated using an expression like the one shown because the data has been grouped by the BI Developer before coming through into the script for the app. I want to be able to compare 'groups' side by side in a table and the only way I have been able to make this work is through using several pivot tables next to each other to compare the data.

      Expressions.PNG

       

      I want to be able to compare 'groups' side by side in a table and the only way I have been able to make this work is through using several pivot tables next to each other to compare the data, as below:

       

       

      Capture.PNG

       

      My question is, is there a way to hide the label column on a pivot table?


      If the alternative is to use a straight table, I haven't been able to make this work as I need to swap the axes so that the labels are lined up down the left hand side, rather than along the top. As an alternative, is there a way to swap the axes on a straight table so that the labels are listed vertically rather than horizontally?

       

      Thanks for any help,

       

      Loren