Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Order | order date |
---|---|
111 | 11/01/2012 |
111 | 11/02/2012 |
111 | 11/03/2012 |
111 | 11/04/2012 |
222 | 11/03/2012 |
222 | 11/09/2012 |
333 | 11/01/2012 |
333 | 11/06/2012 |
444 | 11/10/2012 |
444 | 11/13/2012 |
See attached qvw
Count(Distinct [order date])
this will give the distinct count of order date.
Thanks a ton Renjith , that helped.