Forum Discussion

irfan_abdrhman's avatar
1 year ago
Solved

Linking Children with Parent

Hello Community, Here is the Source Data where I'm currently stuck at, So the idea is that the Number column represents the Parent, and the Expense Items.Number represents the children. So the ...
  • p45cal's avatar
    1 year ago

    See if the table at cell BA3 in the linked-to workbook below is any help at all.

    See last column and I've sorted on it (on the sheet, not in PQ).

    The only bug is with Cement-OPC which has 2 parents.

    Hopefully there is only one level of child (children don't have their own children).

    The workbook: https://app.box.com/s/qnwb56ggi80y0f0l3cdzmg9z23osaonu