I am creating an App for BOM analysis (Bill of Materials) for a client. Need help in Data model to set Hierarchy of Data, and roll up the Cost to find the UNIT_COST of any item. Below is the example Data.
Also attaching the QVW file that I tried (but in vain).
HierarchyBelongsTo works, but I am not able to Drill down from Top to Bottom with the Cost breakup.