hi, Jeannette !

I am bringing in the data below from SQL Server.
I cannot add a calculated field because it is removed when it is refreshed.
The issue is with the SUM of the GP% ((GP $/Sales)*100).
I manually added another column to the right for only the ones that are wrong and what it needs to be.
Spent too many hours trying to resolve this one.
Data
Store Order No Description Sales GP $ GP% GP% Needs to be (...)

*if* you cannot add a calculated field... how/where/... do you get the data for your PT 6th field/column "GP%" -???-

*if* you add a calculated field every time your PT is refreshed (by code) ?
- try "constructing" a(nother) field from your query to your sql-server data
you might need to *group by* (order or description) -?-

if any doubts (or further informacion)... would you please comment ?
hth,
hector.