field in rows count values total

[#1]

I need for one field given different rows available repeated rows please show below

   S.NO           NAMES

           1.       1.John

           2.       2.Raju

           3.       1.John

           4.       3.Muni

           5.       1.John

           6.       2.Raju

Result: 1.Jhon=3,2.Raju=2,3.Muni=1

please write  set analysis

[Kushal_Chawda]

Create the Straight table

Dimension: Name

Expression: Count(Name)

[Chanty4u]

hi,

PFA

[ecolomer]

Is this you need?

[sunny_talwar]

Where exactly are you trying to show this information? in a straight table or text box??

[#6]

i tryed to text object

result is ok

=count({<NAMES={'3. Muni'}>}NAMES)

[ecolomer]

could you check my proposal