I need to create the pivot table and pivot chart based on the sharepoint list data 2010.

Please help.


  • 3
    Share something that you have tried. – Harshini Hegde Jan 6 '14 at 7:38

If you have SharePoint and SQL in integrated mode then you will get an option on the list ribbon to add the list as a data source to PowerPivot.

If not then see if this helps? http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/07/11/excel-services-using-a-sharepoint-list-as-a-data-source.aspx

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.