Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to terminate on a tab a dimension so that they can no longer be filtered? In our case it would be the departments in the hospital. Although they are to see in the diagram, but they should not be filtered. In another tab, this limitation should not be present.
Perhaps you can use set analysis expressions in your chart. With set analysis expressions you can override user selections. That way you can make charts independent of user selections with regards to one or more fields.
Another way might be to use sheet de/activation trigger which deselect + select and lock fields.
- Marcus