Forum Discussion
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 ...
Thank you for your reply. So I get the data as per the attached diagram straight from mySQL server. In the report, I'd like a matrix with the category - sub-category and sub-sub category and the distinct counts of the client IDs coming from that table.
I'm not sure how to achieve this, as I can't make all those relationships active 😞
Thank you so much