2 Replies Latest reply: May 12, 2015 5:46 AM by anbu cheliyan RSS

    Distinct Records in Chart

      Hi Friends ,

       

      I have a requirement

         

      CountryLIST TYPEMAR
      AEBICBMCADR1
      AECILBMCADR1
      AEBICBMCADR3
      AECILBMCADR4
      AUBICBMCADR5
      AUCILBMCADR6
      AUAUMBMCADR6
      INDAUMBMCADR8
      INDBICBMCADR9
      INDBIC

      BMCADR10

      In the Above data , i have to build a chart based on the Country code as Dimension and Count (List Type) as Expression

       

      Condition : I should Consider the List Type with only DISTINCT MAR (Out of 10 MAR , only 8 are distinct)

       

      Regards,

      Senthil