Disable selections for other tabs

[#1]

I am working on KPI's report that does not use the same selection fields on all of the tabs (worksheets).

For example - date selections are only necessary on the first tab but not on the rest of them.

What is the function that i would need to use to specify where and how to use which selections? ,

Thank you for your help!

[mato32188]

Hi Zhenya,

in your expression use Set Analysis like sum( {<Field1 = >} Sales) = lets say, it would not react on your Field1 selection...

M

[#3]

Hi,

Use Set analysis as @martin has suggested..It will make charts independent from user selections.

[Colin-Albert]

Set Analysis changes how any selections are applied to an expression.

sum({1} Amount) will ignore all selections.

sum({1 <Region = {'USA'}>} Amount)  will give the total for USA ignoring all other selections.

sum({1 <Region = {'USA'}, Year={2014}>} Amount) will give the total for USA & 2014, ignoring all other selections.

I would suggest using the {1} set for your KPI expressions and add any specific filters as set modifiers to the expressions.