I have a requirement where a user only wants to aggregate specific data that appears below a hierarchy.
The filter source is based on a table calc, so I'm not sure if this is possible.
Attached and screenshots below illustrate what I'm looking to do:
I only want the rows below the hierarchy aggregated when the table calc field "SumCheck" =1.
So the rollup should like this:
