1 Reply Latest reply on Jun 20, 2016 3:02 PM by Yuriy Fal

    Bringing upper hierarchies into view through filtering on the lower ones

    joe.rodriguez.3

      Hey Guys,

       

      I have simple parent-daughter hierarchy or relationship below. There will be two sheets, one showing parent revenue and another one showing daughter revenue. My main and only filter will be the daughter (incoming javascript parameter). So, if I filter by daughter filter 'A1' on that sheet, how do I automatically bring parent 'A' total (not just A1 revenue) revenue into view on the other sheet. On the attached workbook, the parent A should reflect $30.

       

        

      Parent DaughterRevenue
      AA1$10
      AA2$10
      AA3$10
      BB1$10
      BB2$10
      BB3$10

       

      It's sounding like some LOD's and total functions which I am trying to avoid. Any help would be appreciated!!

       

      Joe