I have a custom list created that tracks project status by stages. I need to present the same in a chart format. Below is the list information.
Status for each of the phase is NA, WIP, Completed.
Output required is Stage wise total counts of Status. Below is view on status for 5 projects.
Development(Phase1) - WIP(1) - NA(2) - Completed(2)
Testing(Phase2) - WIP(1) - NA(3) - Completed(1)
Deployed(Phase3) - WIP(0) - NA(4) - Completed(1)
Can this be done using CAML or DVWP XSL.
Any help would be appreciated.