User defined aggregation at different product level

[arifshah]

We have a product table that has different level of hierarches like product l1, product l2, product l3, product l4 and product l5. This product table is connected to the sales table which shows the sales by product at different levels.

Now the customer has decided that they want to have control over the aggregation of products. They want to create their own table where they can define an extra aggregation column and mention in that aggregate tables which products are to be aggregated at different level. For example take a look at this image

The custom aggregation column is what the user wants to see in the chart. The other columns are what the customer wants to aggregate.

The challenge here is that the user has only selected few of the products and not all of them. It will require a join with the product table. The join should be so that if multiple levels are mentioned by the user then they should all be part of the join with the product table. However, If only one level is mentioned and other levels are empty then only that level should be aggregated and joined with the product group.

I have not found a simple way of how to let the user define their aggregation where the user wants to have contorl on what level of product they want to aggregate and also mention only the products that they want to aggregate.

Is there any simple solution to achieve this?

[lbendlin]

No, there is not.  Unless you consider rejecting that request as a simple solution.