9 Replies Latest reply: Sep 18, 2013 5:21 AM by Thomas Jensen RSS

    Pivot/Straight table show dimension on dimension



      I have a problem which i simply does not know how to solve.


      As it is now, when i select a item in my barchart, i have a straight table, which shows all related items (but only in one box) -

      This means i cannot sort the values based on another column.


      Then i made a pivot table, with an expression and hereby i can sort them by this field - BUT i dont want to show these values, and as we know, you cannot hide a column in a pivot table.


      My question is then. How would you do this?


      How would you show all related items sorted by an expression? but without showing the expression values...


      I have attached a sample file.


      Thanks in advance.