1 Reply Latest reply on Oct 9, 2013 11:24 AM by Matt Lutton

    Filter detail based on table calc below hierarchy when collapsed?

    Stan Bush

      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.

       

      hier_expanded.png

       

      So the rollup should like this:

      hier_collapsed.png