Set Analysis function for Category Sales when Product is selected

[madnanansari]

I have the below Product Master Table in my app:

PRODUCT_KEY

PRODUCT

..

..

CATEGORY_KEY

CATEGORY

..

I have a requirement to design a table for product sales. The below is the table Attributes required:

PRODUCT

PRODUCT SALES VALUE

CATEGORY SALES VALUE

Here the category Sales Value is the total sales for the specific category to which the product belongs to.

I know this can be done by Set Analysis. Someone can guide me please?

[shraddha_g]

Can you give screenshot of your data model?

[madnanansari]

My data model is very detailed. I cannot share as is.

pls. take any simplest standard sample with PRODUCT dimension or any other and SALES fact.