a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software.

learn more… | top users | synonyms

0
votes
0answers
5 views

Using Pivot table with list to graph data with mm/yy in x-axis

I have a sharepoint list that has a number of record entries. It also has a calculated column that converts the "submitted date" to a MMM/YYYY format. I then used the microsoft excel services to ...
0
votes
0answers
10 views

Limit the Excel Service

I've two question about Excel Service on SharePoint: I would like to disable the field list panel for Pivot Table in the Excel I'd like to disable the Download option except for the Download as a ...
0
votes
1answer
184 views

Pivot Table Source Data in Separate Excel Workbook stored on sharepoint

I have an excel spreadsheet on the sharepoint server with my Main Data that I want to analyze. I want to make a pivot table from this sheet that will update when the Main Data is updated, but I need ...
0
votes
1answer
29 views

Is there any way to pin Pivot table or charts in share point?

I have prepared a excel sheet and prepared some pivot table based on it. Can we pin it in sharepoint so that I can refer it whenever I want?
0
votes
0answers
434 views

How to create a Pivot table template?

How do I create a Pivot table based on my Excel sheet data and save it on Sharepoint only so that I can directly use it for my reference as and when required?
1
vote
4answers
6k views

Can a multiple value “lookup” column be displayed as checkboxes in a SharePoint List?

I have one list to store information about people, and another list storing a list of tasks each person should achieve. I'm trying to create a SharePoint view which allows users to enter/modify ...
0
votes
1answer
140 views

Example of Public site with List Filters

I am looking for an example of public SharePoint site that allows multiple filtering on a list of results. For example, the visitor should be able to filter a list of announcements, or a list of ...
1
vote
2answers
1k views

Display Pivot Table based on Listdata using SP 2010 Standard Edition

I need to create a pivot table on a webpart page with multiple x dimensions based on list data. e.g. ----Status Started Completed In Progress ----Prio Hi Lo Hi Lo Hi Lo Task A ...
1
vote
3answers
528 views

How are you creating reports out of lists?

I have 2 lists I need to create reports out of including pivot like reports. What's your recommendation for doing so and still present it on a SharePoint site? look up list Sample List A 1 X 2 ...