I have a table with multiple row headers. While not formally a hierarchy, they do act like one when collapsed and expanded.
I’d like the aggregation to be different depending on which level is expanded / collapsed.
If I have a sales measure for each salesperson, and each salesperson has a team, and each team has a location. I’d like to:
- Show an individual’s sales when both levels are expanded
- Show the average sales when the team level is collapsed
- Show the sum of #2 when the location level is collapsed
(This is a made-up example, don’t overanalyze it haha)
I’ve looked at a few options, like
Totals Calculation Rules but it doesn’t seem to be what I’m looking for. Or is it?