Pivot Table with Calculated Item Shows Rows with No Data

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

Unfortunately, I get the following:

Please Login or Register  to view this content.

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.