I am not sure if this is a PowerPivot question or rather just a Pivot table issue.
I have a Power Pivot data model and I have created pivot table on the model.
When I click on the Beta Region / Actuals (the yellow) cell, I get two different experiences between the Excel client and the SharePoint Excel Services version.
In the thick client, I drill to detail onto a new sheet. On the web version, nothing happens. I can "explore" data, but it is more about navigation and not drilling to details.
Any idea how to get the SharePoint Excel Services to drill through to the detail stored in the Power Pivot data model.
http://darren.gosbell.com - please mark correct answers
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?