Ideally your data would be in the correct “shape” for the required reporting. I was discussing something here the other day:-
https://bobj-board.org/t/211973
However, it should be noted that this is a universe level solution and is dependant on having a calendar and creating a derived table.
Mak 1 
(BOB member since 2005-01-06)