2 Replies Latest reply on Jun 28, 2016 6:20 AM by Maddy Pena

    Different hierarchical levels on the same graph

    Maddy Pena

      Hi guys!

      I'm having trouble presenting headcount information for my organization. We have different levels of location: Business unit group (BU Group) > Site.

      What I need to do is to present two particular BU on the same graph, by Site; as presented here:

       

      But I need to "summarize" the data from BU 2 to show only one bar (as in, the upper lever), while keeping the detail of the other BU. Something like this (I made it in paint):

       

      Does anyone know how could I achieve this without changing the data? I'm attaching a sample workbook.

      Thank you all for your time!