0 Replies Latest reply: Apr 29, 2016 9:03 AM by Vitor de Assis Pereira RSS

    (((Line1 - Line2) = Line3) - Line4) = Line5 (Pivot Table)

    Vitor de Assis Pereira

      Hi!

       

      I'm really struggling with this.

       

      Need to create a pivot table with 2 colums like this:

       

      A

          101

      B

          201

          202

          203

      C

      D

          401

          402

          403

      E

       

      Lines at the second colum (that don't end in "0" (zero) are my data.

      Lines at the first colum are the calculated Dimensions. See:

       

      A (= 101)

          101

      B (= 201 + 202 + 203)

          201

          202

          203

      C (= A - B)

      D (= 401 + 402 + 403)

          401

          402

          403

      E (= C - D)

       

      I already know how to do A, B and D. To achieve that I've added a Calculated Dimension with:

      =Pick(WildMatch(......)......)

       

      This made it group the lines:

      101 inside A

      201, 202 and 203 inside B

      401, 402 and 403 inside D

       

      I'm strugling with C and E, because I need them to be at the same Colum. (if the only way to do this, is with C and E at a different colum, unfortunately, then so be it.)

       

      Can you help me?