Hi all, and thanks for your help in advance.

I'm having trouble with a calculated item in a pivot table that when created adds records to the pivot table that have no data. Any help would be greatly appreciated.

My pivot table has the following data:

PivotField1 | PivotField2 | Type | Data
---------------------------------------
A           | D           | One  |    1 
A           | D           | Two  |    2
A           | E           | One  |    3
A           | E           | Two  |    4
A           | F           | One  |    5
A           | F           | Two  |    6
B           | G           | One  |    7
B           | G           | Two  |    8
B           | H           | One  |    9
B           | H           | Two  |   10
B           | I           | One  |   11
B           | I           | Two  |   12
C           | J           | One  |   13
C           | J           | Two  |   14
C           | K           | One  |   15
C           | K           | Two  |   16
C           | L           | One  |   17
C           | L           | Two  |   18
I made the column pivot the Type field, with the row pivots the PivotField1 and PivotField2 fields. I also made my data the sum of the Data field. The resulting pivot table looks like this:

Sum of Data                 | Type      
---------------------------------------
PivotField 1 | PivotField 2 | One | Two
---------------------------------------
             | D            |   1 |   2
A            | E            |   3 |   4
             | F            |   5 |   6
---------------------------------------
             | G            |   7 |   8
B            | H            |   9 |  10
             | I            |  11 |  12
---------------------------------------
             | J            |  13 |  14
C            | K            |  15 |  16
             | L            |  17 |  18
---------------------------------------
So far, so good. I then try to add a calculated item to the Type field, named Three, which is defined as "= One * Two". I would then expect the following:

Sum of Data                 | Type      
-----------------------------------------------
PivotField 1 | PivotField 2 | One | Two | Three
-----------------------------------------------
             | D            |   1 |   2 |     3
A            | E            |   3 |   4 |    12
             | F            |   5 |   6 |    30
-----------------------------------------------
             | G            |   7 |   8 |    56
B            | H            |   9 |  10 |    90
             | I            |  11 |  12 |   132
-----------------------------------------------
             | J            |  13 |  14 |   182
C            | K            |  15 |  16 |   240
             | L            |  17 |  18 |   306
-----------------------------------------------
Unfortunately, I get the following:

Sum of Data                 | Type      
-----------------------------------------------
PivotField 1 | PivotField 2 | One | Two | Three
-----------------------------------------------
             | D            |   1 |   2 |     3
             | E            |   3 |   4 |    12
             | F            |   5 |   6 |    30
             | G            |     |     |     0
A            | H            |     |     |     0
             | I            |     |     |     0
             | J            |     |     |     0
             | K            |     |     |     0
             | L            |     |     |     0
-----------------------------------------------
             | D            |     |     |     0
             | E            |     |     |     0
             | F            |     |     |     0
             | G            |   7 |   8 |    56
B            | H            |   9 |  10 |    90
             | I            |  11 |  12 |   132
             | J            |     |     |     0
             | K            |     |     |     0
             | L            |     |     |     0
-----------------------------------------------
             | D            |     |     |     0
             | E            |     |     |     0
             | F            |     |     |     0
             | G            |     |     |     0
C            | H            |     |     |     0
             | I            |     |     |     0
             | J            |  13 |  14 |   182
             | K            |  15 |  16 |   240
             | L            |  17 |  18 |   306
-----------------------------------------------
Is there any way to remove the rows with no data? I've tried using an if function to check if the value is > 0, but that doesn't seem to help.

Thanks again for your assistance.