Set Analysis Excluding All and Giving selection One field

[Surya]

Dear All,

Required Help on Set analysis to Exclude All fields (i have more than 100 fields) need to give user to select only(location) one field.

Please help me out to get exact.

[lironbaram]

Hi,
you should use something like this :

sum({1<location=p(location)>}Sales)

[Anil_Babu_Samineni]

Don't allow the user to see them as well using section access, Otherwise you can try

Only({< $(=concat({1< $Field -= {'Ignore_FieldName'}>} $Field, ' ,')) >} Location)

Or

Only({< $(=concat({1< $Table = {'Calendar'}>} $Field, ' ,')) >} Location)