I have a crosstab which returns revenues in a variable number of rows with 8 columns (2 years and 8 quarters). Below the grand total row, I want to add a row with a set of 8 fixed numbers (which change very rarely, and for technical reasons cannot be data sourced in Framework Manager). I then want to add one further crosstab row which adds these fixed numbers to the 8 grand total numbers returned by the query.
I've played with query calculations, defined contents and singletons, but am struggling to find the magic recipe. Does anyone know if/how this might be achieved?