0 Replies Latest reply on Nov 19, 2013 10:58 PM by sreekanth.upputuri

    one dimention can not go into the group by

    sreekanth.upputuri

      Hi Experts ,

       

      I have two dimensions and one measure for exp: Market Area, Product tyep (Dimentions) and Sales Revenue(Measure)

      if drag  all three into my work sheet my data will come like Market area and product type wise Sales Revenue data . but my requirement is sales Revenue data is not divided into Product Type wise .

       

       

      For exp:

       

      Select Market Area,

      Product Type ,

      Sum(sales Revenue)

      From Test

      group by

      Market Area

       

      Product type is not going to Group by .

       

       

      For Exp : See the attached Screen short data in need same for kind of measure data if use in product type not going to divide into details wise