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
0answers
3 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
8 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
13 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
16 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
10 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
45 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
12 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
32 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 ...
0
votes
1answer
23 views

Displaying data in Excel Pivot Tables

I am working on a project and being able to use a pivot table would make life much easier. I need essentially for one column to become the column labels which is fine, however I would like to display ...
0
votes
0answers
9 views

Pivot Table loses Custom Sort Order when saved

I have a Pivot Table in Excel 2010 on which I have sorted one column with a Custom List: Jan-2008 Feb-2008 [..] Nov-2025 Dec-2025 This works fine until I save the workbook. When I re-open the ...
0
votes
0answers
9 views

Excel 2013 Pivot Charts: will not display multiple series

I have a table of data that I copied into Excel 2013. It looks like the following: City Month Category AvgCount Houston, TX Jan 1 0.05 Houston, TX Jan ...
0
votes
1answer
84 views

Two-way data update with Excel PowerPivot tables (Office 2013)

Background: We have two excel workbooks: Data and Visual which we are using to track and visualize activities in our project. The Data file is organized like a database: each sheet is a table (which ...
0
votes
0answers
47 views

Excel 2013 PivotTable refresh slow when source data file is not open

I have an Excel workbook with ~3800 rows and ~380 columns. In a different workbook I am using a PivotTable which references this monolithic workbook. I am seeing an issue where if the source ...
1
vote
1answer
19 views

Possible to create and switch between views/configurations of a pivot table

Is it possible to save different configurations of a pivot table and easily switch between them? For example, one configuration that has certain values along the X and Y axes, another configuration ...
1
vote
2answers
45 views

How to get the count of the most frequent matching columns?

Need some help figuring out how to do this in Excel. I have a long list of names split up into 2 columns - the first and the last name. I'd like to figure out what are the 5 most popular full names ...
0
votes
0answers
16 views

Auto expand does not work between sheets in excel 2013?

I have a sheet with values from an access DB. As the DB expands, so does the sheet. But I also have links in another sheet to the first one, and they do not auto expand. Can anyone help me figure out ...
3
votes
2answers
141 views

Can I customise the new Timeline slicer in Excel 2013?

Excel 2013 introduces timeline slicers for the first time. These allow you to filter pivot tables easily by selecting time ranges - either by year, quarter, month or day. It's nearly a useful tool, ...
0
votes
1answer
29 views

Automated weighted counts in a Pivot Table (Excel)

I have data for sales people who work with different clients. Sometimes the sales person has multiple deals with the same client. I want to be able to work out the count for each sales person for each ...
0
votes
0answers
13 views

Show Pivot Table values as percentage of another Pivot Table's values

I have two pivot tables with identical axes to each other - a list of countries down and across either side. Each table has a count of different types of interactions between the countries as values, ...
0
votes
0answers
34 views

Excel pivot table with the categorical variables in multiple columns

My data consists of a series of registers (patients) with some properties (Age group, Sex) and the result of four observations of the same categorical variable (Healthy or Sick): Subject_Id ...
1
vote
0answers
59 views

Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time? See the PivotTable below as well as the source data (both excerpts). If it is in fact not possible to ...
2
votes
1answer
42 views

Is it possible to add a custom calculation for a top level row total in a pivottable?

My Pivot Table has the following format Manufacturer MPG - Nissan 10 - Petrol 35 - Model A 30 - Model B 40 - Diesel ...
0
votes
1answer
57 views

How to keep pivot table from expanding into occupied rows and columns

I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations ...
3
votes
1answer
65 views

Data transformation in MS Excel

looking for help on converting data from one format to another - If you want to see data in sheet is here - ...
2
votes
1answer
53 views

How can I use Excel to monitor my payable?

Here's what I wanted to happen, I have five columns Supplier Amount Payment Supplier1 Supplier2 When I have a receipt of my payable, I'll encode the name of supplier and it's amount. When ...
1
vote
1answer
45 views

Budget planning with Microsoft Excel

I have an Excel worksheet which is regularly populated with daily expenses: Then to extract a report on the amount of money spent on each category, I simply use a pivot table like below: I am ...
2
votes
1answer
81 views

Excel - How to include a count of blank cells in Pivot Table?

My Pivot Table totals the occurance of various strings in my column. Some of the cells are blank. I want the "blank" category to display a total count. How is this done? Similar unanswered question ...
2
votes
1answer
45 views

Excel pivot table - unable to get graph to display correctly

I have a pivot table (Excel 2013) of results for a helpdesk. In column A it lists the agents, grouped by year (this divides up into months). In column 2 it lists the number of tickets closed by each ...
0
votes
0answers
36 views

IF statement is false, do nothing - GetPivotData [duplicate]

Unfortunately, I'm unaware of an if statement that will leave a cell unchanged when the if statement is false. Goal - If the text in Column E matches the value in B1, I want it to take the data ...
1
vote
1answer
90 views

Data reconciliation with pivot table

I have 2 tables (table1, table2), each with 2 categorical variables/columns (product, country) and up to 5 real-valued variables to be reconciled/compared against each other (sales and other in the ...
1
vote
1answer
368 views

Pivot table 'page fields' usage

In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still useful. The process starts by pressing Alt, D, P. In one of steps there is one ...
0
votes
1answer
304 views

Excel 2011 for Mac/ Pivot table / tabular layout how to “fill down?”

I've got a great pivot table in tabular layout, but how do I "fill down" values in column A? A10 should also read "Alpaha Police" A15:A18 should also read "Atkinson Co Sheriff"
0
votes
1answer
62 views

Monthly Pivot Tables In an Annual Report

I was given 12 tables of purchase orders (one for each month) that my school has made and was asked to create an annual report listing purchases for each month which is pretty simple. The thing is ...
0
votes
1answer
28 views

Whats an easy way to fill in empty cells after copy and pasting from Pivot table classic layout?

I've run a report on products sold and used a pivot table to see products by customer. I then need to upload the data back to SF and so I have used the classic pivot table layout to be able to copy ...
0
votes
2answers
33 views

Month by Month Pivot Table

I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...
0
votes
0answers
49 views

Prevent Field Collapsing in Excel PivotTable

I am working with Excel 2013 Pro, using PivotTables. The fields in PivotTable are published into hieararchy so there are folders on top and field-values on bottom of hieararchy. What I am having ...
0
votes
0answers
20 views

Issues with Excel pivot table denying access to original file

I currently have a pivot table that is referencing an external data source. The connection is to another excel spreadsheet on our shared server. When importing I select the tab that I want to use and ...
0
votes
0answers
19 views

Strange behaviour of pivot table - entry masked

I've a very strange issue in Excel 2010 pivot table. One entry of my data gets replaced to " " (space) in pivot table. "GR45ZF1402010" is not visible as you see below, if I change just one character ...
2
votes
1answer
101 views

Pivot Table Slicers. Can I ensure one specific item is always selected?

I'm using Excel 2013. As in the title, I have a slicer (connected to a pivot table and pivot chart) and I'd like to make sure one specific item in my slicer is always selected whilst allowing ...
0
votes
1answer
30 views

How to sum up weighed normalizations of columns?

Say, I have a sheet with the following (simplified) structure with absolute values: What I want to achieve is to get a table with the normalized values (i.e. the maximum is equivalent to 1. In my ...
1
vote
1answer
723 views

Excel pivot table, difference between fields in the same column

I have table that has the same account names but for different years (sample below). I want to create a pivot item field that calculates the difference between the years for the same account name ...
2
votes
2answers
68 views

Average of Count of Cells for Day of Week in MS Excel

I'm looking to do an average of rows per week day. And so far, I haven't been able to figure it out. I'm using Excel 2011 for Mac. Here's a sample screenshot: Here's the screenshot of the ...
0
votes
1answer
125 views

Multiple Label Filters in a pivot table

Is it possible to have multiple label filters in a pivot table? I see that I can use 'contains' which could work but I am having issue with the syntax if this is possible. I'm thinking something like ...
2
votes
1answer
40 views

Excel pivot table: Show values instead of summaries

I have a table of data like this: ID |Name |Brand |Model |License ------------------------------------ 1 |Foo |KOM |830 AC |A 1 |Foo |KOM |930 E |B 1 |Foo |CAT |980 H ...
0
votes
0answers
38 views

Excel Daily Average Profit [duplicate]

I have a table that looks like this..Just two column..Date and Profit: Date--------------Profit 24 - March------25.00 24 - March------19.85 25 - March------5.25 26 - March------6.36 26 - ...
0
votes
0answers
397 views

Multiple Values in one cell needing separate row in Pivot Table

I am looking for a solution on how to have a separate row in a pivot table for 2, 3 even 4 values in one cell. Example - Columns are as follows: Date, Job Name, $ Value, Distributor Quoted, ...
0
votes
2answers
188 views

Weird Calculated Field behavior in a Pivot table in Excel

Intro: I wanted to add an index to a pivot table I wanted to add an index number (1, 2, 3, ...) to the rows of my pivot table. After some experimenting, I ended up adding a column to my source table ...
0
votes
0answers
24 views

Excel - Grouping Columns in pivot table

I am having trouble grouping columns in a pivot table. 1.There are no blanks in the rows for the columns I am trying to group. All fields have been formatted as General The Range of the Pivot ...
0
votes
1answer
19 views

Excel pivot table breaking up for whole number items

I couldn't think of a better title. Please bear with me! I have the data as the following image shows: I create a pivot table using the range 'Sheet1'!$A$1:$E$33. The table displayed is as ...
1
vote
0answers
166 views

How to calculate average daily sales for each month in a pivot table

I need to calculate the averages I have in a month. What I'm expecting is to calculate 936, 184, 943, and 230 and get an average of 573. However, when Excel calculates these values in a pivot ...