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,
- Edited by pauldelke 14 hours 22 minutes ago