Is there a way to allow users to “drill down” into data without effecting other, concurrent users?
I have created a document with a fair number of connected tables. I used a control to display only the data relevant to a specific user (not just the current user), filtering multiple tables and presenting a summary.
However, in taking the team through this doc, I realised that controls are shared. We were all effecting each other’s view of the document.
Is there a way to allow everyone from the team to actively work with the same document, applying their own control values?