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
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 ...
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 ...
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 ...
1
vote
0answers
96 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 ...
0
votes
1answer
121 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
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 ...
0
votes
1answer
754 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?