Pivot Table - return orginal value for all

[staggerlee011]

Hi all,

Im importing some data from SQL which contains rows like:

SERVER ALERT RESULT
a 1 0
a 2 20
a 3 52
b 1 1
b 2 23
b 3 5
c 1 23
c 2 10
c 3 3

I was hoping i could pass it into a pivot table and return Row = Server Column = Alert and Value = Result, But its accumilating them. Is there any way to simply return the actual value? ie:

Server 1 2 3
A 0 20 52
B 1 23 5
C 23 10 3


Hope someone can help.

S

 

[ParamRay]

.
.

Insert a pivot table with "Server" as a row field, "Alert" as a column field and "Result" as a data field with sum function...

 

[staggerlee011]

thanks had a dippy day,