Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [pivot-tables]

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

1
vote
0answers
87 views

Creating summary metrics/tables from list data

I wondering if the below mockup is achievable within SharePoint. I have a list containing a number of checks, each which have a type and status (Pending/Complete/Approval Needed), is it possible to ...
3
votes
2answers
63 views

Can I do a pivot chart on Sharepoint, from a list with ~1M entries? And will it perform ok?

as mentionned above I would like to have a pivot chart, or a pivot table, on Sharepoint accessing ~1M rows, with up to 100 variables. I'm a beginner with Sharepoint and I'm not aware if it would ...
0
votes
1answer
119 views

How do I configure a chart webpart?

I have a service desk task list that tracks the number of service requests by service person and is filtered by certain criteria. These tasks are tracked on an hourly basis. I'm new to Chart web parts ...
0
votes
1answer
749 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
50 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?
1
vote
4answers
7k 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 people,...
0
votes
1answer
146 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
2k 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 ...
2
votes
3answers
537 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 ...