I need to create the pivot table and pivot chart based on the sharepoint list data 2010.
Please help.
Thanks!
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityI need to create the pivot table and pivot chart based on the sharepoint list data 2010.
Please help.
Thanks!
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