A Pivot Table is a table of data that can pivot or rotate around a specific point in that data, whether it be a data type or category.

learn more… | top users | synonyms (1)

0
votes
1answer
28 views

Can PivotTable create Pareto buckets?

Is there a way to use a pivot table to create cumulative buckets or brackets...from either built in functionality or a back-door method? My analysis is to show aggregate data for items that comprise ...
3
votes
1answer
16 views

Excel 2013 Pivot table, how to filter rows/columns before pivoting

I have some raw data in my spreadsheet with columns like role, role status, object, object status, so the data indicates the relationship between role and object. The some data view looks like ...
0
votes
0answers
13 views

Converting traditional pivot table to data model based

When creating a pivot table, there is an option to add data to the data model. If a pivot table was originally created without this option enabled, is it possible to convert it to a data model backed ...
0
votes
0answers
11 views

grouping columns in pivot table with data model

It seems that I lose the ability to group columns if I create a PivotTable with "Add to Data Model" option (which I need to be able to do unique counts). Is there a different way to do grouping once ...
0
votes
0answers
25 views

hide filter in pivot table

I created a pivot table from the following data: Salesperson | Amount | Include? John | 100 | Yes Jane | 350 | Yes Jim | 200 | No Jack ...
0
votes
1answer
36 views

Dynamically populating a pivot table with multiple worksheets in Excel

I have a workbook that contains individual sheets for each month. Each sheet contains these columns: Publication Title | # of Downloads | Month | Year Each worksheet has 200+ entries, where ...
0
votes
0answers
20 views

Excel Conditional Formatting disappears unless smaller dataset in filter

Conditional Formatting on a Power Pivot (Excel 2016 32-bit) using a Color bar is working nicely when results are page filtered to a smaller subset. But when nothing is filtered, the CF disappears, so ...
1
vote
1answer
35 views

Conditional formatting between 2 sheets

I've got a conditional formatting question I'm really hoping someone can help with. I've got a workbook with 3 sheets - "Total Data", "Pivot Table" and "Expired Data". Pivot Table is extrapolated ...
0
votes
0answers
13 views

Show non-value columns on the same row in a pivot table

I have a pivot table based off of the "current data", an example of both are shown below. I want to show some columns in a tabular fashion and then show a second level of information in a pivot ...
0
votes
1answer
14 views

Pivoting Text in Excel

I have an excel spreadhseet where I am pulling in data from an external data source. I really would like to group and/or pivot the data to use for data validation. What I want to do is take this: ...
0
votes
2answers
11 views

Excel PivotTable: Multiple Rows from Multiple Columns

I had the following data in Excel: Points | Categories --------------------------- 25 | Cat1, Cat2, Cat3 15 | Cat2, Cat3 19 | Cat1 20 | Cat1, Cat3 But since I couldn't really show ...
0
votes
2answers
21 views

How do I SUM only distinct values depending on criteria?

The question is simple but the answer probably complicated. I have lots of data, but to be brief I gather everything in two columns. Column A, contains random names, and column B amounts. Based on the ...
0
votes
1answer
43 views

Cannot sort Excel Pivot Table by two or more columns

I want to sort my Pivot Table by two columns. I've searched the web for some time, and it seems Excel doesn't allow this, so I need a workaround. My data Desired Outcome I want to summarise this ...
1
vote
1answer
16 views

name for a pivot table

is there a way to refer to a pivot table using a range name? I want to have another table with calculations based on what's in the pivot table, but I want to use range names to make sure my ...
1
vote
2answers
50 views

Get tab delimited text from a specific column in excel

I have an MS Excel 2013 spreadsheet in which I have the list of some people attending a conference, their address, phone number etc in different tabs. Now, I've been asked to create a tab delimited ...
1
vote
1answer
24 views

Top Percentile by Group

everyone. Can anyone please help me with the following? Any pointers or assistance is appreciated! I have a subset of the dataset with +500,000 rows that looks like this |— Group —|— Name —|— Value1 ...
0
votes
0answers
32 views

The query could not be processed: File system error: An error occurred while opening the 'File Path\file_name.cub' local cube file

Please Help Me !! What happen and how to fix it ? It occurred when I open Pivot Table in Access 2010. (My OS is Windows 10) File Path\file_name.cub is always changed every time database is opened. Now ...
0
votes
1answer
61 views

Filter wrong data out of pivot table in Excel

I've a lot of data I must analyse but some data is wrong. That gives a problem for draw my pivot charts and tables. If there were no errors the chart must look like this: But it doesn't. Here is ...
0
votes
1answer
25 views

Cannot edit Pivot Table Style

I'm trying to modify my custom PivotTable style in Excel 2013. However, when I right-click my custom style, and select Modify, nothing happens. Normally I'd expect the Modify PivotTable Style ...
1
vote
1answer
25 views

'Count Distinct' and Min(date) in the same pivot table?

Is there a way to have in the same pivot table two value columns, one of which uses Count Distinct and the other uses Min(date)? It seems that to have Count Distinct as an option I need to select ...
0
votes
0answers
35 views

Conditional formatting to highlight differences between 2 pivot tables in Excel

I have an Excel issue I hope somebody may be able to help me with please? I have 2 pivot tables that both contain the following fields: 'Provider ID' in the Rows area, 'Month' in the Columns area ...
3
votes
1answer
25 views

Dates in Excel 2013 Pivot Tables

I am collecting daily KPI data but my baseline data was reported monthly. I have 30 departments and 5 KPIs. I set up my raw data collection tool in Excel and plan to pivot the data. Can my ...
1
vote
0answers
16 views

How to compare one row to others in DAX in Excel

I have this table which has foreign keys from several other keys: Basically, this table shows which students registered in which module run by which teacher in what term. I want to query the ...
2
votes
1answer
17 views

Calculate % of filtered values from all values in Excel Pivot Table

I have this pivot table that currently shows how many students failed in a particular subject in a particular academic year. That is, it is now filtered by Pass_Status Fail(which can be either Pass or ...
0
votes
1answer
30 views

Excel pivot table field grouping problems (numbers seen as text)

I have a table which contains columns for activity names, start dates, and end dates. In a new column I calculate the time remaining for each activity with: INT(EndDate - Today()) The INT() is there ...
0
votes
1answer
36 views

Is there a way to hide the Field List in an Excel PowerPivot table so that no users can see it?

I've got a dashboard created via PowerPivot that, when the charts are selected, allows users to open the PowerPivot Field List, so they can see things like, for example, the email address of the ...
1
vote
0answers
27 views

Pivot table column filters

I have a list of data in Excel 2013 with dates ranging from January 1, 2014 to November 25, 2015. I want to display columns from November, 2014 to October, 2015, whether they are empty or not. ...
0
votes
0answers
38 views

Conditional formatting of pivot table cells based on value of a separate field

I have a pivot table which has, for the purpose of this question, "document-ID" as a row label, "person" as a column label and "date signed" as value field. Is it possible to give each cell containing ...
0
votes
0answers
32 views

How do I combine two pivot tables on a shared column in excel

I have two pivot tables that share a column of data. I would like to combine them so that the data attached to the shared column is lined up with the appropriate item in the shared column in one ...
0
votes
0answers
36 views

Excel pivot table grouping issue with 1904 date system

When I use 1904 date system in an Excel workbook I experience a pivot table grouping issue. After grouping for a date field in pivot table, the date values are shifted by one day. An example of the ...
0
votes
0answers
18 views

Get 2 graphs from the same column (dates) in 1 pivot table?

I have a constructed a pivot table, where a single column Field is filled with dates, and I would like to do a comparison between subsets of values in only this particular column. So let's say Column ...
2
votes
2answers
93 views

Excel survey data pivoting, plotting and analysis

I have a set of data from Google forms survey. I ran into a problem representing the data for a specific question type, grid to be exact. So for example you get a question like this one: and ...
0
votes
0answers
15 views

Is it possible to pivot on a table twice?

Background: I have three tables in my power pivot data model. Students [1…n] StudentsClasses [n…1] Classes Classes: - ID - Name - Building I want to do a pivot table that does the following: ...
0
votes
0answers
20 views

How can I turn table column headers which hold dates into pivot table and be able to consolidate by fiscal year or quarter

I have a table that we use to standardize client company financial information. How can I manipulate this table so that I can easily use pivot tables and group the dates by Year or by Quarter? ...
1
vote
0answers
38 views

Can't calculate % of row in Excel Pivot Table

Product types A, B, C, D Each type has numerous products, say type A has 100 products, type B 50 etc.. product# product type buyer 01 A john 02 A ...
0
votes
0answers
18 views

Filter data from pivottable to only current day

I have a pivottable where I amongst others have a date column/row. In a regular table I can put a filter on "current day" however this is not an option in the filters for the pivottable. How can I get ...
0
votes
0answers
22 views

Suggestions for Staging table for XML ETL?

Suggestions for Staging table for XML ETL? Thanks for responding to my threads and looking into this issue. We have a large XML message file. We want to extract the data from this XML file and load ...
0
votes
0answers
17 views

Filtering Pivot Table

I have this Pivot Table, and what I need to do is: Filter this data and show only those records whose date (3rd column) is equal to its parent date (2nd column) or just 1 day difference is there. And ...
0
votes
0answers
14 views

Pivot Table Calculated Field

I have 2 values in my pivot, RepCount and WonOpps. I want to insert a calculated field to get the average # of WonOpps per RepCount. When I insert a calcualted field it does not sum as expected. ...
1
vote
1answer
35 views

Calculate/determine in MS Excel which filetype/product has been ordered first (complex table)

I'm using MS Excel 2013 on a Windows desktop computer. The original worksheet I'm working on contains about 200,000 rows, or 4,000,000 cells, and is about people who downloaded a .pdf file, ordered ...
0
votes
0answers
9 views

Pivot Table Report Filter Field Format

In my data source I have one of the field, Delivery Date in the format of short date, e.g. 13/01/15. I would like to create a pivot table having Delivery Date as the Report Filter. I would like the ...
0
votes
0answers
16 views

Excel: transposing multiple entries [duplicate]

I have this kind of list and would like to turn it into this type of list thus allowing me to select all first occurence, all second occurence etc.. So I used the pivot table to list the ref ...
0
votes
0answers
12 views

Failing to use a split cell range as data source for a pivottable

I want to create a pivot table from this table I have, but I want to leave out some of the rows. So, suppose I want to keep the header row, leave out the next ten rows, and use the next 10 rows. This ...
0
votes
0answers
32 views

Connecting slicer to mutiple pivot tables

I am trying to use a slicer connecting multiple pivot tables. When I try to connect to the other tables the list is blank. I try to connect to data sources and it shows no other data sources in ...
0
votes
0answers
31 views

How to merge Excel PivotTable results with another sheet?

I have an Excel spreadsheet, where I have a PivotTable where the X is Location & Commodity. The Y is Fiscal Year. The cell data is a sum of Commodity cost. The PivotTable is being generated from ...
0
votes
1answer
65 views

Making a pivot table month filter

I'm trying to compile some reports through an Excel pivot table connected to a MS SQL database. Now the data I'm working with consists of a bunch of dates formated as dd/mm/yy. I want to make a filter ...
0
votes
0answers
18 views

Handling exported reports from BI portal in Excel 2010 causing performance issues?

So, I'm going to try to describe this the best I can. Multiple uses at my office will often export large reports from the BI system of the SAP web portal. These files can be as large as 25-50mb, ...
1
vote
1answer
372 views

Scatterplot of categorical values from pivot table

I am trying to create a scatterplot of two categorical values in Windows Excel 2013. I tried putting the values into a pivot table, but cannot create an XY chart type with a chart that has been ...
0
votes
1answer
26 views

Change pivot table layout into “more columns”

When I create a pivot table in excel 2010 my table looks like that: Any suggestions how to get this extra colume filled up with the names within a pivot table? Or do I need to use power pivot? How ...
1
vote
0answers
87 views

Hiding pivot table field using a button

I have a pivot table in Microsoft Excel 2010 with several row and column labels. For the sake of user friendliness I would like to have several movable, clickable buttons which each hides/shows one of ...