2 Replies Latest reply on Aug 9, 2012 5:49 AM by Amer Ghanem

    Applying calculation to the rest of non-filtered data

    Amer Ghanem

      Hello,

       

      I have the following setup for each product

      Product Category,

      Product Subcategory,

      Product Name,

      Sales

       

      I have a filter for Category, that will only show me relevant Subcategories. What I am trying to calculate is the sales of one Subcategory to the rest of the subcategories in one category based on a user selection.

       

      Assuming that I have two Categories A, B. and 3 subcategories for each, A1 A2 A3, B1 B2 B3.

      CategorySubcategory
      Product
      Sales

      A

      A1P1

      5

      AA1P25
      AA2P310
      AA2P410
      AA3P515
      AA3P620




       

       

      If the user selects Category A, and Subcagory A1, I want my result table to look like

       

       

      Subcategory
      Sales
      A1$10
      Other (A2+A3)$55


       

       

      If the user selects Category A, and Subcategory A2, I want my result table to look like

      Subcategory
      Sales
      A2$20
      Other (A1+A3)$45


       

       

       

      Thanks