Showing Grand Total columns for select Calcs when using a Calculation Group in a Matrix....

[Anonymous]

I have some data which needs to be presented like this:

For past (fully completed) quarters, I only need to see one Measure (Sales). Fur current/future quarters, I need to see a few Measures. I could easily build this in 30 seconds if I didn't mind seeing Plan/Prior/Delta for the PAST Quarters even though they were empty (and Sales for the cur/future Quaters even when they're empty), but that looks awful. (Speaking of, there should be a built-in way to hide any NULL columns in a Matrix, but I digress).

Many hours of scouring the internets later, I have worked out how to (mostly) do this via a Calculation Group. I create Sales/Plan/Prior/etc Calc Items, and then add the (DateDim) Quarter to the Matrix Columns, add the Name of the Calc Group to the Matrix Columns, then click the "expand all" drilldown button (a tip that none of the tutorials happened to mention), and I can see my Quarters (and the "Measures" in each one), and only the populated Calc Items show up for each Quarter.

The problem is, then I can't show TOTAL year Measures, because there is no such thing as the "Total" Quarter, (and by using a Calc Group, I basically "break" the Subtotal logic of the Matrix so it can't be displayed anymore).

So, is there a way to say, "Show me these Calc Items by Quarter AND THEN show me a grand total of these Calc Items after that"? I'm guessing I would have to somehow generate a "Total" Quarter and then run the same Calc Items through that, but I don't know how to do that.

I should note that I'm also open to completely different ways of achieving the above sample (assuming any exist).