Cross Tab - A field with multiple values as a summary field

[saran26]

Hi All,

I have a dump question, is it possible to use a field with multiple values as a summary field in cross tab.

For Example

I have field called users in my table grouped by locations

can i use that field in the cross tab repor t and generate a report like



Location1 user1
user2
user3

Location2 user4
user5

Note - user1,user2 and user3 are part of a single field called Users

Please help me out.

Thanks
Saran

 

[lbass]

You could add user as a second row field and then also add user as a summary field, using a maximum summary. Or you could use NthSmallest(1,user), Nth Smallest(2,user), etc. It's just that you would end up with a lot of white space if one location didn't have many users.

-LB