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!