3 Replies Latest reply on Feb 22, 2016 8:38 AM by Shinichiro Murakami

    Add unfiltered data as ReferenceLine to filtered data

    Ramz Aftab

      Hello experts!

       

      I have a scenario where I have to use Parent's percentage as a Reference line in one of it's sub group. Group C is selected in Filtered data, where it shows 60%, 20% and 20% in respective Aging buckets. Then there's a Group's percentage that is in orange, stating 23%, 58% and 19%. How can I do it so that parent group's percentage is set as reference line, and it's set on top of Group C(filtered group). So Ideally, if I filter it to any of the parent's subgroup, the Parent's percentage is added as a ref. line to show how subgroups are performing as compared to parent's percentage.

       

      I have attached workbook for this example. Help will be much appreciated. Thanks!

       

      Capture.JPG