4 Replies Latest reply: Jul 24, 2015 5:16 AM by Philipp Schöck RSS

    Chart (Pivot)Table Dimension Vs. Expression

    Philipp Schöck

      Hi all,

      I really want to  know why it is not possible to display different Expressions in one column that belong to the same dimension in a Chart Table

      I have something like this:

       

      BusinessUnitOrderNumber
      1-2-31111
      1-2-52222
      1-2-33333
      5-5-51234
      1-2-35555

      And I want to display it like this:

       

      BusinessUnitOrderNumber
      1111
      1-2-33333
      5555
      1-2-52222
      5-5-51234

       

      BusinessUnit is my dimension and OrderNumber is my expression.

       

      So maybe I havent understand the difference between dimension and Expression correctly.

       

      If I do this in a TableBox it is nearly working. Because then I get this:

       

      BusinessUnitOrderNumber
      1-2-31111
      1-2-33333
      1-2-35555
      1-2-52222
      5-5-51234

       

      But I want to have it summarized.

       

      It would be nice if somebody could halp me with this problem.