You can create a table by doing a resident load on your previously loaded table in the script. It would look similar to the attached. You can do things a bit differently based on how you want to group, but the overall idea is there.
Let me know if you need further explanation.
test.qvw 149.5 K
Thank you very much good sir!!
Your solution will be marked as correct but just as a caveat to others: My 'completedactivity' was a date and I could see the example values that Chris put in the load were example numbers - which clearly would work when CompletedActivity = 'None' but not when it wasn't :-)
For Chris: I dunno if this was a long-winded solution but I simply created another date field and ran the month() function on it (first function that popped into my head), then I populated the LOAD statement as:
LOAD * INLINE [
Which took into account all possible date values to filter (as there are only 12 months )
This is most likely not the cleanest approach to a solution but it works - if any others have any suggestions I am as ever open and grateful!