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.