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

    Pivot/Straight table show dimension on dimension

      Hello,

       

      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.