set Analysis - returning a list of Names by Department

[#1]

Hi,

I am trying to use set analysis to return only a list of Names against certain departments.

I have used set analysis before to return a numeric value but I dont now how to return a Field conataining Names

TOTAL({<Department={'Football', 'GAA'}>} NAME)

I dont know what function to use at the start to return a string of names, before I used sum / num TOTAL when I was returning numberic values.

Thanks

Gregg

[#2]

Hi Miguel,

=Aggr(ONLY({<Department = {'GAA'} >} NAME), NAME)

I have tried but still only returning the same data as above. Not sure whats goin on as both fields are linked when I check in a table box.

Joe Bloggs    -

Derek           -

Paul             -

Thanks Again,

Gregg

[jagan · Accepted solution]

Hi,

Check attached file for solution.

Regards,

Jagan.

[#4]

Hi Jagan,

I checked your script and added noticed you had the expression in the field.

I had been adding the expression in the expression tab - this disn't work.

Thanks both for your help.

Regards,

Gregg

[#5]

Thanks Miguel

I got it working.

REgards,

Gregg

[swuehl]

Gregg,

please check that all field names are correctly spelled including case.

What if you just do a

=aggr(NAME, NAME)

?

OR

=NAME

?

Then I assume you want to filter the list, and I also assume you are currently using the expression tab to enter the expression above. What you need to do is using an expression as field (open the field drop down list, at the very end ---> <EXPRESSION>

Hope this helps,

Stefan

[#7]

Thanks Stefan,

That was the issue I was having.

Regards,

Gregg