1 Note to make in the example code, when instructed to copy & paste out on each section of code where you have written [Calendar Year] on the Columns there is a double space between the two words which will error the query.

Query (2, 14) The MEMBERS function expects a hierarchy expression for the argument. A member expression was used.