I need to count the different total number of records from the table as table has column which contains records in hierarchic way.
Ex. Column name: CatName, which contains data like Catalog, Doc, Folder, Files. When it's design into portal as below.
Catalog ==> IT, HR, FIN, Legal
Now under IT, it has another Folder and Document and files like: Network, DR and each contains files
So I need to count how many IT records then under IT, how many Folder, then under each folder , how many files.
I hope i have clear instruction what i want it,.