Set analysis - allow only one field to change expression result

[#1]

I know how to use $ and 1 in set analysis. But how do I make it so that only certain fields can alter the calculation. i.e. If the user selects Region, the value changes, but if they select Product it doesn't.

[sudeepkm · Accepted solution]

You may use like below. Below expression will ignore the value of Product selected.

sum({<Product= >} SalesAmount)

[swuehl]

Maybe like

=sum({1<Region = $::Region>} VALUE)

[its_anandrjs]

By pass your selection or ignore the selection like

Sum({<Year=,Month=,Product= >} Value)

[#5]

Is it possible to do the inverse? So instead of telling it what fields to ignore, tell it what fields to not ignore?

[sudeepkm]

please see Swuehl's answer. sum({1<Region = $::Region>} VALUE)

[#7]

you can try this:

sum({1<REGION = {$(=GetFieldSelections(REGION))}> sales}

This will alter the calculation only if one or several regions are selected.

[lukaspuschner]

you could use alternate states