I have more of a conceptual question if anyone has examples or some ideas of how others have accomplished this.
On a sales reporting site, a user should be able to pull information based on the following hierarchical structure:
- Account Level
- Department Level
- Division Level
The categories are encompassing as you move up the chain (ie. Dept includes all accounts within that group). A user could have access to several groups within each tier. But a user would not have cross-category filters (ie. both a Department & Division level filter).
Would all this be accomplished in a single table with a column indicating the filter level and several rows per user with each criteria? What other suggestions are there?