Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

0 Replies