We are currently trying to limit the number of filters that can be applied at any one time so that the granuarity of the data is restricted.
I have tried various changes in the the data model to acomplish this but cannot find a work around.
A toy example would be that a table might have 4 columns.
Client, Region, Type, Value
We would like it so that you can only filter by either "Client and Region" or "Region and Type" or "Client and Type" but not "Client and region and Type"
Most of my attempts focused on using dependant filters to try and prevent the option to select al 3 at anyone one time, but either the data no longer was displayed or the fiter allowed you to filter when it should not.
Please sign in to leave a comment.