1 2 Previous Next 19 Replies Latest reply on Jun 13, 2016 3:00 AM by Allen Gapara

    Automatically Select a parent by selecting a child

    Allen Gapara

      Please help, I am having a small problem with the Workbook attached. Under regional Totals, I would like to be able to select the region Totals by selecting the venue where it is based. I have tried LODs and several different things, but nothing is working. When I select a region, only that region total should appear. It looks like a small thing but I am missing the trick.

       

      Totals should the venue totals and Regional totals, the region Total. I want them to see their region as well by just selecting their venue. Thanks for your help.

        1 2 Previous Next