software

I have created a calculated field in my pivot table. It works properly.
However, the column and row totals do not give intended results (sum of
displayed results). Rather they use the same formula on all data in that part
of the table. Here are the details:

Data
Table shows payments by transaction for all customers (field name=AMT).
Customer may have and - payments on any day. I need to show net payments
per day by customer. I then need to calculate 31% of net payment BUT only if
net gt;0.

Pivot table: created 2-way table, calculating sum of pmts by customer by
day. works fine

calculated field: =if(AMTgt;0,AMT*.31,0). works fine in body of table

totals: table does not calculate total of displayed results of formula,
rather reruns formula on underlying data.
example: 2 customers, one has net pmts of 30, formula shows 9.3, second has
net of -20, formula shows 0. I want total of 9.3. table shows total of 3.1
(30-20)*.31.

Any suggestions?

Thanks,
Jakesee response in worksheet.functions

--
Regards

Roger Govierquot;Jakequot; gt; wrote in message
...
gt;I have created a calculated field in my pivot table. It works properly.
gt; However, the column and row totals do not give intended results (sum
gt; of
gt; displayed results). Rather they use the same formula on all data in
gt; that part
gt; of the table. Here are the details:
gt;
gt; Data
gt; Table shows payments by transaction for all customers (field
gt; name=AMT).
gt; Customer may have and - payments on any day. I need to show net
gt; payments
gt; per day by customer. I then need to calculate 31% of net payment BUT
gt; only if
gt; net gt;0.
gt;
gt; Pivot table: created 2-way table, calculating sum of pmts by customer
gt; by
gt; day. works fine
gt;
gt; calculated field: =if(AMTgt;0,AMT*.31,0). works fine in body of table
gt;
gt; totals: table does not calculate total of displayed results of
gt; formula,
gt; rather reruns formula on underlying data.
gt; example: 2 customers, one has net pmts of 30, formula shows 9.3,
gt; second has
gt; net of -20, formula shows 0. I want total of 9.3. table shows total of
gt; 3.1
gt; (30-20)*.31.
gt;
gt; Any suggestions?
gt;
gt; Thanks,
gt; Jake
gt;