5 Replies Latest reply: Dec 14, 2011 9:24 AM by Marko Banjanin RSS

    Set analysis in a dimension

      Hi all,


      This is my data set (e.g.)


      Product,       Seller

      AB_12,         A

      AB_13,         B

      AB_14,         C

      BB_11,         D

      BB_12,         E

      BB_13,         F

      CC_12,         G

      DD_12,         H


      I'd like to build a sales table with a dimension that only displays those Sellers that sold a product starting with "AB*" and "BB*"


      I get the set analysis part of it ... {<Product= {"AB*", "BB*"}>} but get an error when trying to display only relevant Sellers.


      How can I build this dimension to show only relevant Sellers?


      Many thanks!