SSAS IgnoreUnrelatedDimensions and Grand Total behaviour

I'm stuck on some things. If F Qty is selected I want Sales Line Selling Quantity to repeat. I don't want to change the global setting 'IgnoreUnrelatedDimensions' (as we have lots of users using this measure and it will affect all their spreadsheets) is it possible to do this in MDX in the 'calculations' tab?

Also I don't want F Qty to aggregate (basically you can have multiple forecasts at multiple months) so summing them doesn't make sense. They still want to analyse F Qty side by side against Sales Line Selling Quantity. Is it possible to turn off or hide the grand total for a column? If not, how can I display the last value that isn't a 0 as a grand total?

Also if I can get the Sales Line Selling Quantity to display my forecast accuracy calculation should work.

To hide the aggregation of F Qty I would use a SCOPE calculation, something like this:

SCOPE ( [ForecastOffset].[ForecastOffset].[All] , [Measures].[F Qty] ); This = null; END SCOPE;

I'm guessing the dimension name for the ForecastOffset attribute.

This should appear after the definition of [Measures].[F Qty] (if one exists in the Calculated Measures script).

For Sales Line Selling Quantity another SCOPE calculation might work, e.g.

SCOPE ( [ForecastOffset].[ForecastOffset].[All].CHILDREN , [Measures].[Sales Line Selling Quantity] ); This = [ForecastOffset].[ForecastOffset].[All]; END SCOPE;