pivot table calculated item creates unneeded rows


S

sophie

I need to add a calculated item for a pivot table
I tried to add a caculated item to field F3. Formula1 = C + H (see below)
The resulting PT has some added unnecessary rows.
This is a simplified version of the table. The original table has 500 rows
under f2 field and they are all repeated for each of field F1 and given a
formula1 item with zero values.
Is there a way to avoid these unnecessary rows.
Many thanks for your time.

original Pivot table


Data
F1 F2 F3 oct nov dec
R1 m mn C 2 1 4
R2 G 5 6 3
R3 H 9 5 5
R4 ms C 3 5 1
R5 G 5 4 3
R6 H 4 3 2
R7 w wn C 6 8 7
R8 G 10 13 15
R9 H 6 8 9



Pivot table after adding item to field F3. Row R9,R10,R11 are unneeded.

Data
F1 F2 F3 oct nov dec
R1 m mn C 2 1 4
R2 G 5 6 3
R3 H 9 5 5
R4 Formula1 11 6 9
R5 ms C 3 5 1
R6 G 5 4 3
R7 H 4 3 2
R8 Formula1 7 8 3
R9 wn Formula1 0 0 0
R10 w mn Formula1 0 0 0
R11 ms Formula1 0 0 0
R12 wn C 6 8 7
R13 G 10 13 15
R14 H 6 8 9
R15 Formula1 12 16 16
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unneeded warning box 0

Top