Name:  Capture4.jpg
Views: 269
Size:  19.5 KB

Hi I have put two row groups , year and month, if I only want a 1 or 0, for those columns with a Date Instructed in that Time period , how do I do it?

Name:  Capture5.PNG
Views: 255
Size:  7.3 KB

So the Count of ActualStartDate, will only be those rows with a DateInstrcuted in that month.