topic Re: Set Analysis Excluding All and Giving selection One field in App Development

Set Analysis Excluding All and Giving selection One field

Surya — Sat, 16 Nov 2024 01:11:41 GMT

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 — Mon, 02 Nov 2020 07:23:34 GMT

Hi,
you should use something like this :

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

Anil_Babu_Samineni — Mon, 02 Nov 2020 07:32:23 GMT

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)

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