How to duplicate custom subtotal in a SSAS Pivot Table

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 14 hours 22 minutes ago
August 28th, 2015 12:47pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics