Calculated Items + no calculation zero lines calculated item field

When I use the calculated item field, it lists every calculated item, regardless of whether there is actually data in the row it is calucalting. So I end up with the pivot table listing a lot of zero info, and it makes for a table a lot longer than it needs to be.
Is there a way the extra lines with zero in the calc item field can be made that there is no calculation?

You would think the pivot table would only produce values for existing rows, but it calculates a value for every line in the pivot table, regardless of whether there is data in the line item. For example, say the pivot table is calcing the following data:
Acct Num Actual Budget
61100- 10 5
61200- 0 0
The result of a pivot table would only list the first row (the second would not show, as there is no actual data to summarize on the report). When I add a calculated field (budget-actual), ALL rows show up on the table, even those that start out as not showing. It looks like the calc item now has a "0" value (becuase 0-0=0). And that is causing all account numbers to show, even when there is no value in them.

How can I insert a calculated item that only make a calculation when there is a value in the calculated item???

Try doing a sumif in the underlying data and setting a helper column value to "hide" if zero else "show" and the use that as a filter in the pivot table.

Unfortunately that's not an option...the data range is to large..12 MTD colums and 12 YTD columns => 24 calculated Items into 1 scenario (for example only in an Actual scenario...and I've got more scenario's).

So I need really a solution that I can modify the options for a pivottable and calculated items...I think there is no other solutions tha write something in VB and change the properties of a calculated field.