Hierarchy - Cost roll up in BOM

[manoranjan]

Hi All,

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.

Please help.

Thanks

Mano

[frank_bossuyt]

might be a bit late but this is an example of how I did it