3 Replies Latest reply on Aug 6, 2018 7:07 AM by Zhouyi Zhang

    Dynamic List showing Main Level and relevant Level+1

    Kamil Nikiel

      Hi,

       

      I got puzzled I want to present costs for Organization(Main Level) listed per cost line, and on a different sheet I want to show total costs for each sub organization of the chose main level (Level+1).

      I want this list to be dynamic so if i select organization 2 i will see sub organizations for Organization 2

       

       

      Attached is my workbook with dummy data, Dashboard shows how I want it to look, have no idea how to make it dynamic.

       

      Would anyone be able to help?