Disable selection of a specific dimension

[CarlosV]

Hello!

I would like to make pivot table values ​​static based on a parameter list of a dimension even though there is a List Box based on the same dimension which is used to perform selections.

Sample data:

Possible values (used as filter) (List Box)

Operation

1

2

3

4

Full data set

Code	Operation	Value
1	1	10
2	2	25
3	3	5
4	4	10
5	1	15
6	4	25
7	2	40
8	3	50
9	3	20

What i want, regardless of selection in List Box:

Code	Operation	Value
1	1	10
5	1	15
2	2	25
7	2	40

I tried many variations of Sum({$<Operation = {'1, '2'}>} Value) , but unsuccessful. Any suggestion? Thanks.

[rwunderlich]

Sum({1<Operation = {'1', '2'}>} Value)

-Rob

[CarlosV]

Hello Rob, thaks for your reply.

Unfortunately this expression will block the selection in other dimensions. I need only block the selection on Operation dimension, the Code dimension can still be selected.

[rwunderlich · Accepted solution]

"I need only block the selection on Operation dimension"

Your original expression should work then (you were missing a quote in what you posted). 

Sum({$<Operation = {'1', '2'}>} Value)