Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Zhenya,
in your expression use Set Analysis like sum( {<Field1 = >} Sales) = lets say, it would not react on your Field1 selection...
M
Hi,
Use Set analysis as @martin has suggested..It will make charts independent from user selections.
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.