Field values as headers merged with existing fields

[Esky73]

Error Scheduled Successful Failed FieldB FieldC FieldD
10 100 500 5 String String String

Desired output is above :

I would like a table showing a count of the statuses in Field A - as column headers (Errors, Successful, failed etc) inline with fields B > D
How to bring this together ?

i have tried with transpose=header_field=FieldA and also played with xyseries - but unsuccessful so far.

thx

[Sukisen1981]

hi @Esky73
Not clear at all... what are your fields and what is your output? can you provide a better desired output sample?