How to total columns in crosstab where there are measures nested on the rows

Resolving The Problem

Use the "within set" clause in the total() function.

Steps: Using Go Sales (analysis) Sample package

1. Create Crosstab object
2. Add the Year from the Time dimension to the columns of the crosstab
3. Add Product Line from Products dimension to the rows of the crosstab
4. Nest [Unit price] from the Sales measures to right of Product Line
5. Nest [Unit cost] from the Sales measures to the right of Product Line and below Unit Price
6. Select "Product Line" in crosstab and choose 'Total' under the Aggregate button.
7. Select "Unit Price" and "Unit Cost" in crosstab (use shift button to allow for selecting both) and choose 'Total' under the Aggregate button.
8. Select the "Total(Unit price)" and nest this to the right of the "Total(Product line)"
9. Select the "Total(Unit cost)" and nest this below "Total(Unit price)" to the right of the "Total(Product line)"
10. Double-click the "Total(Product line)" and change the expression
    from:
    total(currentMeasure within detail [Product line])
    to:
    total(currentMeasure within set [Product line])
11. Double-click the "Total(Unit price)" and change the expression
    from:
    total(currentMeasure within detail [Unit price])
    to:
    [Unit price]
12. Double-click the "Total(Unit cost)" and change the expression
    from:
    total(currentMeasure within detail [Unit cost])
    to:
    [Unit cost]