0 Replies Latest reply on Jun 14, 2015 10:59 PM by Sankarmagesh Rajan

    Selected customer first Letters and others view wth count of selected and other?

    Sankarmagesh Rajan


      Create calc as [first letter]

      Left([customer name],1)


      Create parameter and string and list add [first letter]



      Create 2nd calc as [Selected and others]

      if [Calculation1]=[Select Name First letter] then [Customer Name]  else "Others" end



      Drag this calc into row and show parameter control and select letters.



      Create new calc as [selected count and others]

      if [Calculation1]=[Select Name First letter] then "Selected" else "Others" end



      Drag this [selected count and others] into row and drag customer name into text and select count.


      now we can get selected and other count and also selected customers and others data in view.