this problem I have to solve is more that what I can handle.
A table had 5 specific fields: PRODUCT_NAME, PRODUCT_SIZE_1, PRODUCT_SIZE_2, PRODUCT_HEIGHT, PRODUCT_COLOR. Each field has a range of values.
The "PRODUCT" is defined by a mix of combinations of all 5 fields above.
The problem I need to solve is to produce (using a reasonable speed) into an other Table: (1) a Portal showing how many of each product has been sold every year and (2) a vertical bar chart representation.
Many thanks for your suggestions,