Forum Discussion

grazib's avatar
grazib
Regular Visitor
3 years ago

Relationship and hierarchy

Hi there, I have 3 tables which hold categories and sub-categories as a hierarchy – not my model, but it came straight from mySQL like this: - Category – categorID is the unique ID - Sub-category ...
Need Help
TotunG's avatar
TotunG
Icon for Resolver I rankResolver I
3 years ago

Seems like you need to simplify the hierarchy into one main Hierarchy table then link the 3 tables (which have the hierarchy values) to relate to this main table which you can then do your calculations from. 

 

Might be good to do a quick mock up of your PBI data if you can and post here if more help needed.