What I need to do is show all Month names with values from the same table:
Month FinalD Value
(COUNT of FinalD Value)
January Inpatient 100
February ER 229
March Acath 322
April ARAD 444
What I need is top5 with another column showng count of FinalD.
this is what i have tried so far but I only get Month and the FinalD
"MONTH" = Datename(month,( DateInserted)),(FinalD)
Where status = 'Completed'
GROUP BY Datename(month,( DateInserted)),FinalD
Order By Datename(month,( DateInserted)),FinalD Desc
The result is: