text value on CrossTab view

[amit.barkai]

Hi All

after adding the wanter row and colunms to my cross tab view , as far as i understood .

to see any data  a mesureable field was needed.

what i wanted to know if there is a way to use a text field 

for example if my regular data is

HostName  ItemType  ItemValue

Host1             AAA           111

Host1            BBB           222

Host1            CCC          333

the wanted CrossTab should be

HostName      AAA       BBB       CCC

Host1               111       222         333

 

thanks