8 Replies Latest reply: Feb 22, 2018 5:54 AM by Kirsten Zawierucha RSS

    Select a child and get all children which belong to its parent

    Kirsten Zawierucha

      Hi all,

       

      I want to select an article in a listbox.

      In a pivot table I need to get all ticketnumbers in which this article is sold.

      Furthermore I want to know the other articles which are sold with the selected one.

       

      The ticketnumbers are the parents and the articles are the children

       

      I have used an expression like this:

      =sum({<TestArticleNumber=p({1<TestTicketNumber=p(TestTicketNumber) >}) >} TestAmount)
      

       

      I don't get why it does not work...

       

      I also added my project so you can take a look.

       

      If you have any idea, please let me know!

       

      Regards,

      Kirsten