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
BR 00000231 SPRING RED 11.99 6.49 54.13
00000231 Total 11.99 6.49 54.13
00000232 SPRING RED 11.99 6.49 54.13
00000232 Total 11.99 6.49 54.13
00000233 BALL RACK 49.99 24.99 49.99
00000233 Total 49.99 24.99 49.99
00000234 BLUE PUP 39.99 19.49 48.74
00000234 Total 39.99 19.49 48.74
00000236 BLUE PUP 39.99 19.49 48.74
SPRING RED 11.99 6.49 54.13
SPRING YEL 11.99 6.49 54.13
00000236 Total 63.97 32.47 156.99 50.76
00000237 READ RACK 14.99 7.49 49.97
BLUE PUP 39.99 19.49 48.74
SPRING RED 11.99 6.49 54.13
00000237 Total 66.97 33.47 152.83 49.98
00000238 BALL RACK 49.99 24.99 49.99
00000238 Total 49.99 24.99 49.99
00000239 SPRING YEL 11.99 6.49 54.13
00000239 Total 11.99 6.49 54.13
BR Total 306.88 154.88 620.93 50.47
Grand Total 306.88 154.88 620.93 50.47

Any suggestions would be greatly appreciated.

Jeannette

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.