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?