AnsweredAssumed Answered

Complex calculation

Question asked by vincer on Nov 25, 2017
Latest reply on Nov 27, 2017 by vincer


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,