We converted a pivot table from looking at an SQL Server view to a SSAS cube. The users have lost the ability to add a custom subtotal to the 2nd row field. How can I duplicate this functionality?

Here's a link to a sample workbook: Compare PTs with Subtotals.xlsb

And here's a screen shot:

Thanks,

Paul

• Edited by pauldelke Friday, August 28, 2015 4:46 PM

Hi pauldelke,

According to your description, you want to custom the subtotal for the second member on rows. Right?

In this scenario, since you want  your custom calculation to apply on the second member only, you can only modify the calculation in SSAS cube instead of the Pivot Table. You should specify SCOPE statement for the second member.

SCOPE([Date].[Calendar].[Calendar Year].&[2013],[Measures].[Internet Sales Amount]);
      This= --your custom calculation ;
END SCOPE;

Please refer to links below:

MDX: Grand Total / Sub Total

N/A For Subtotals

Regards,