Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create the Straight table
Dimension: Name
Expression: Count(Name)
hi,
PFA
Is this you need?
Where exactly are you trying to show this information? in a straight table or text box??
i tryed to text object
result is ok
=count({<NAMES={'3. Muni'}>}NAMES)
could you check my proposal