Clients adding or hiding columns of data on PowerPivot and Sharepoint

Question

I am exploring whether powerpivot on sharepoint would be an adequate substitute for our reporting tool based on excel workbooks

Specifically we use vba and custom forms to allow the user to hide or unhide columns of data in the report - to customize the report to their needs. 

I am wondering if in 2012 powerpivot and sharepoint whether the user would have access to the pivot table field list so they could add or remove columns of data - I know it was not supported before 2012 and can not find it in the descriptions of the new product.

If not, are there alternatives to achieve the same thing - such as using slicers in some unusual way?

Suggestions welcome - thanks

Answer 1

Hi Wilbert,

Is adding or hiding based on user security, or is it just for usability?

the Powerpivot gallery (even in PowerPivot 2012) won't let you modify the pivot table using the browser.  However, you can always download the workbook and republish.

Additionally, you can call the published PowerPivot workbook from other clients, Excel, SSRS, and even non-Microsoft clients like Tableau.  As such, you can create a robust data model in PowerPivot and leave some of the UI features to other tools

---

Javier Guillen
http://javierguillen.wordpress.com/