Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am aware of how Set Analysis can be used to ignore selections. Also, I know that section access limits the amount of data that is visible to a user with limited access.
What happens when you combine these? If you have a Set Analysis statement, such as =sum( {1} [Sales] ), it should total the sales while ignoring any selections made.
Let's say you have a field called Salesperson. One of the possible values is "James Kirk". Even if you select James, the above expression will still give the total sales from all salespersons, including Spock.
Now let's say you have section access that limits Kirk's data to only his Sales. Now what does =sum( {1} [Sales] ) return? Will it still include Spock's sales, or is the value now only the total of Kirk's sales?
Note: I have not been able to find an answer on Google or the forums, even after many searches. I can't find a clear answer or even a case where this exact question has been asked. Many thanks in advance!
It will return only Kirk's Sales.
Section access reduction effectively removes data. As far as data seen by expressions, it's as if the removed data never existed.
-Rob
It will return only Kirk's Sales.
Section access reduction effectively removes data. As far as data seen by expressions, it's as if the removed data never existed.
-Rob