getting noofrows against a field

[Anonymous]

suppose i have a fielda

which has values

2

3

4

5

6

what i need is output number of records from my table against each value of fielda

2      645657

3      67878

4      68678

5      8785

6      678678

[karthikoffi27se]

Hi Dy

Just use Count(YOURFIELD) if you want the overall Count or you can use Count(Distinct YOURFIELD) if you want unique count.

Many Thanks

Karthik

[Anil_Babu_Samineni]

How 2 getting 645657??

[effinty2112]

Hi,

Try a straight table with dimension fielda and expression Count(fielda).

Cheers

Andrew

[Anonymous]

number of records of the whole table against field a

[Peter_Cammaert]

An example of what Karthik explained in the first reply:

You can use any field in the Count() expression, as long as it doesn't contain NULL values. Those will be skipped.

[karthikoffi27se]

Hi Dy,

Please mark the right or helpful answers as appropriate.

Many Thanks

Karthik