how tomake a crossed field query with text "value"?

[laghetto]

how to make a crossed field query with text "value"?

Hi,

first of all sorry for my english.
I need to create a crossed field query like in the file I uploaded but instead of count values of "qualifica_man" have to show me the text.
I can do it but only that field is (on the table) a number type, but this i need a text type.

is it possible to do that?

best regards

 

[laghetto]

this the code for the working parte (numeric field on table)
This is the code for the "numeric" version:

[SQL]TRANSFORM Sum(tab1.numeric) AS SommaDinumeric
SELECT tab1.ID_tab, tab1.mansione
FROM tab1
GROUP BY tab1.ID_tab, tab1.mansione
PIVOT tab1.IdAnno;
[/SQL]