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

    one dimention can not go into the group by


      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