Questions tagged [pivot-tables]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
112 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
64 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
124 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
759 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
52 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,...
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 ...
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 ...
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 ...