Hi, I troubling with the following, say you have the following spreadsheet. How would you convert it to a datamodel in Mendix. Conditions: Label,SubLabel,ProductCode,ProductCosts and SubLabelDiscount can be different each year. The sublabel discount is belongs to a sublabel and can differ for each productcode The productcosts for a productcode can differ each year and are for all labels equal. In screens I would like to start choosing a year then a label, then a sublabel, then a productcode and see the costs and discount
The domain model depends a bit on the needs you have.
Based on the table you shared, would this do the job?