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!