0 Replies Latest reply: Oct 1, 2018 10:37 PM by surfman joe RSS

    how to get a selection's attributes?

    surfman joe

      Hello, I have a table as attached one. my question is, once an item is selected, how could I get sum sales and profit of the selected item's category as well as its sub category?

       

      for instance, if item D is selected, I want to get item D's category B's total sales/profits, and sub category Ba's total sales/profits.

       

      If item D and L are selected, I want to get category B plus C's total sales/profits, and sub category Ba's plus Cb's total sales/profits.

       

      Can anyone help on write the set analysis expression? thanks.