2 Replies Latest reply: Sep 19, 2017 6:08 AM by Mohammad Adnan Ansari RSS

    Set Analysis function for Category Sales when Product is selected

    Mohammad Adnan Ansari

      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?