3 Replies Latest reply: Apr 4, 2015 2:36 PM by yusuuf rawat RSS

    how can I use wildsearch in dimension?

    Aytac Bas

      there are so many link on my dimension for example;

       

      ref:

      fbp_alb_3456

      gad_1234

      gad_8964

      fb_lnk_7475

      fb_lnk_6549

      fbp_alb_8753

      fbp_alb_2204

      fbp_alb_1067


      etc.


      my expression is count(distinct(sales_id)) but I want to see  dimension as:


      ref (dimention)                  count(distinct(sales_id))                       

      FBP_ALB,                                   4

      FB_LNK,                                     2                       

      GAD                                           2