How to get Distinct Count in Pentaho

In order to get Distinct Count in the Kettel spoon

Go to the design mode drill down the Transformation folder and Drag & drop the  Unique Rows Step

this step remove the double and repeated Rows and give only unique occurrences but this works only on sorted input so you need to set a Sorted Rows Step available under the Transformation Folder jus drag & drop it  and make the hope between the two steps

If the input is not sorted, then only double consecutive rows are handled correctly.