# Questions tagged [pivot-table]

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.

**0**

votes

**0**answers

28 views

### Excel Pivot table - Slicer with only unique features

I have a relatively big database (200 rows and 1000 columns), where one of the columns which is going to be used for filtering (through slicer), has multiple values (e.g., Reason 1, Reason 3) while ...

**0**

votes

**0**answers

6 views

### Use pivot table as a source for making excel tables

Can i use a pivot table as a source for creating a table in excel? If somehow i can create a table from pivot table, i can insert new fields in between the table and can perform some calculations ...

**0**

votes

**0**answers

3 views

### Adding fields in pivot table

I have a pivot table data of some materials dispatched to certain sites. I want to insert two columns in pivot table which calculates the percentage of dispatched quantity against total scope, and ...

**0**

votes

**0**answers

15 views

### Excel pivot table treating money as a string when filtering

I'm connecting to a data model in Excel and one of my dimensions is a decimal datatype - Excel seems to know this because it sorts it correctly when it's displayed in the pivot table. I can't find a ...

**0**

votes

**0**answers

25 views

### Excel: get row labels with range and frequency

Suppose I have a single column of whole numbers from 10 to 29. I want to create a pivot table that looks like this:
I'm having trouble getting these values, though. How can I get a range for each row ...

**0**

votes

**1**answer

53 views

### Excel pivot values column to Text

I have data in Excel pivot and my text data in value column shows number instead of Text . Any one can help me please. In below image of pivot value field red circled:

**0**

votes

**1**answer

23 views

### My excel is missing pivot table in the ribbon

Here is how my excel ribbon looks like:
How can I add pivot table to it?
Regards,

**1**

vote

**1**answer

59 views

### Combine none-unified data in excel based on row-id?

I have the need to combine different excel sheets of data into one single master file.
I have one master file with e-mail addresses and several excel-files from our CRM with data in different ...

**-1**

votes

**2**answers

68 views

### Can Excel Pivot Tables delimit data and perform calculations on the data?

I'm trying to create a document for work to track a lot of information and provide feedback based on the inputs. I have nearly everything I need complete, except the results that occur. I have ...

**0**

votes

**0**answers

33 views

### Can a subtotal Sum only unique values in a Pivot table?

I created a Pivot table in Excel. The field setting for the data's values is set to Max.
I would like the pivot table subtotal to Sum those Max values, but when I change the subtotal field setting to ...

**0**

votes

**0**answers

20 views

### Selecting multiple Excel “Tables” for creating a single pivot table

I have two large sheets in two separate workbooks - 500-600 rows and 8 columns - same headers. It is difficult to mark such a large and dynamic range. But the data is in Excel Table format. I could ...

**1**

vote

**0**answers

103 views

### How do I add custom, dynamic time period averages to Excel Pivot Table?

I have an Excel worksheet that has overtime (OT) data for each person in the company summarized per pay period. My objectives in Excel are as follows:
Show a current pay period summary of OT hours by ...

**1**

vote

**0**answers

39 views

### How to plot timeline chart with start and end date columns

I have a table like this:
| Resource | % | Start | End |
|-------------|-----|------------|------------|
| John | 0.1 | 10/1/2018 | 11/15/2018 |
| Paul | 0.2 | 8/20/...

**1**

vote

**1**answer

93 views

### How can I assign an asterisk to a cell which has been formatted as 'Currency' and is also used as raw data for a Pivot Table?

I have a spreadsheet full of raw data, where I have created a Pivot Table to help organise and manage said raw data.
For the purposes of this question, I would like to use the below image to help ...

**0**

votes

**0**answers

14 views

### PivotChart Expand/Collapse elements in the legend

I have a pivot chart (stacked bars) showing data about different Teams, grouped in Departments, evaluated over time (months/quarters/years).
I want to be able to see the data either of the single ...

**1**

vote

**1**answer

44 views

### Pivot Table won't show correct data relating to the row names

I'm trying to create a pivot table to tell me how many people are coming to different parts of a bachelor party. When I select the "Row Labels", I select that of "Coming Zorb" as they are the same ...

**0**

votes

**1**answer

32 views

### Excel Calculate Date Differences between Orders Per Customer

I have a data-set with Account Names, Order IDs and Close Dates. I would like to see the number of days between orders, per customer, however Excel will not allow me to sort by date in my Pivot Table ...

**0**

votes

**0**answers

41 views

### Is it possible to distribute between start and end date a quantity with Pivot Tables?

This is my first question here.
I have a bulk data sheet (in Excel) where the columns look more or less like this:
Task name - Task originator - Start Date - End Date - Hours
I would like to have ...

**0**

votes

**1**answer

42 views

### Unnest row labels from pivot table

My goal is to use the results of my pivot table as a raw data set for further manipulation, however I can't figure out how to easily break out my nested row labels and copy down the parent value for ...

**0**

votes

**0**answers

20 views

### Excel: In a Pivot Table filter the same value over multiple column

Is is possible in a Pivot Table to filter a value over multiple columns?
I tried advance filter but it is an ugly solution for me as it doesn't keep all the Pivot Table feature list total count, etc. ...

**0**

votes

**0**answers

39 views

### Pivot table not updating available columns from data model source

I have four tables in an Excel 2013 workbook generated from four different ODC files.
Using Power Query, I added all four tables to the Data Model and created a common list in a query. I created ...

**0**

votes

**1**answer

47 views

### Add vlookup multiplier to pivot table

Starting from a table like:
Stock Action Shares
AAPL BUY 100
AAPL BUY 200
MSFT BUY 100
MSFT BUY 200
MSFT SELL -100
and:
Stock Price
AAPL 105.5
MSFT 221.2
I'd like to ...

**0**

votes

**0**answers

77 views

### How to split comma-separated values for Pivot Table?

I have data which has the following format:
Electricity
Electricity, Cooling
Electricity, Heat
Electricity, Heat, Cooling
I want to use this data in a Pivot Table so I can count the number of items. ...

**0**

votes

**1**answer

174 views

### Can a Pivot table transpose values

Starting from a table like this:
Name Grade Subj Course
Dave 9 Math Algebra I
Dave 9 Eng Eng I
Dave 9 Sci Biology
Ed 10 Math Algebra 2
Ed ...

**0**

votes

**0**answers

92 views

### Pivot chart losing format after refresh

I have hundreds of pivot charts and every time i refresh the data i keep losing my data labels on the charts. I'm interested if it's possible to not lose the data labels or for a way to apply my chart ...

**0**

votes

**0**answers

33 views

### Displaying chart legend as a list

I'm trying to find a way in pivot charts to display the legend as a list. Depending on the current month data sometimes there are more/less entries with different data which completely ruins my legend ...

**0**

votes

**0**answers

13 views

### Pivot Table Consolidation - Max Number of references allowed

I was wondering how many max ranges or references to excel workbooks/sheets i can use for Pivot Table Consolidation?
I need to gather data for a whole financial year and I guess This excel command ...

**0**

votes

**0**answers

53 views

### How to Extract Unique Values From Multiple Columns With Pivot Table?

I have 2 columns in Excel. Some of the content repeats in each and vice versa.
e.g
A - 1 2 3 5 6
B - 1 2 4 5 7
I want to compare these two columns and make a new column or list with the unique ...

**0**

votes

**0**answers

40 views

### Pivot grouping disappears when workbook is closed & reopened

I have a workbook containing multiple pivot tables across different sheets.
I spent some time on grouping down these tickets into overall headers.
For example, the following rows:
Meeting 01/01/...

**0**

votes

**1**answer

52 views

### Microsoft Excel - Pivot Table

In an Excel pivot table,
I have September data with items A, B & C; the pivot table looks like below:
September Data
A 20
B 30
C 40
However for October data I only have items B &...

**0**

votes

**1**answer

29 views

### Excel Pivot - I don't want (blank) written in my empty cells

I have created a pivot from data which had many empty cells. After creating the pivot all those cells are displayed as "(blanks)". I want it to remain empty.
I found an answer here https://www....

**0**

votes

**0**answers

17 views

### Bug resolution time graph

I'm documenting the amount of time it takes for a bug to be resolved but displayed in histogram/binomial format to see what the average amount of time it takes to resolve a bug. I was using pivot ...

**0**

votes

**1**answer

36 views

### How to create a text based Crosstab (pivot) in Excel?

Suppose I have a list of issues that have the following:
Priority: 1-5 (how urgent something is)
Impact: 1-5 (how many people will be affected by the problem)
Desc: 15 chars (a very short description)...

**0**

votes

**0**answers

130 views

### How to create dynamic pivot tables in Excel

I am trying to have two pivot tables one after the other, but since their size changes every so often, this means that the first one ends up overlapping the second and thus causing an error. Is there ...

**0**

votes

**1**answer

99 views

### How to have independent columns without sub-level

I have the following data:
I would like the data transformed to the following format:
When I tried to use a Pivot Table it uses the sub-level mode, i.e when calculating hascycle in the above ...

**0**

votes

**0**answers

27 views

### How to persist pivot table formatting in Libreoffice?

Is it possible to persist pivot table formatting in Libreoffice?
I've created a pivot table, and I've formatted a summation column as a percent with no decimals. However, when I refresh the pivot ...

**0**

votes

**1**answer

142 views

### Date as X-axis in Excel

Excel "latest" version (very recent at least, with the Ribbon interface, 2018).
Fighting with dates to be used as X-axis labels in a chart.
The data below came out of a Pivot table; when selecting ...

**1**

vote

**0**answers

57 views

### Format the table output from 'Show Detail' on a Pivot Table

I am using Excel 2016, and pivot tables.
When I use the 'Show Detail' function or double click a value form the pivot table, I get the drill down of the data.
However it is always in a basic format. ...

**0**

votes

**1**answer

22 views

### How to not have sum on pivot-table excel spreadsheet

I have a pivot-table excel spreadsheet.
As you can see below, I'm currently having sum in it.
What I would like is to have just, the value without summing.
I checked on the internet and so far, no ...

**0**

votes

**1**answer

83 views

### How to create a count table of two variables in excel pivot

Is it ok to cross post this question?
I am struggling with creating a count table of two variables at the same time. Ultimately, I would like to create a bar graph of the table.
Assuming I have two ...

**2**

votes

**1**answer

679 views

### Excel Pivot with percentage and count on bar graph

Is it possible to create a Pivot bar graph that Shows percentage and Count in the same bar? I only have Excel 2010
MWE:
Firm Product
1 Car
2 Ship
3 Car
4 Ship
5 Car
I can easily ...

**0**

votes

**1**answer

76 views

### Update table starting from today's date in Excel

I have an excel worksheet similar to the following -
Col A - Clients name,
Col B - Col D - Cient's info such as address, Phone no etc and
Col E - Date of next meeting.
I want to create a table ...

**0**

votes

**0**answers

21 views

### Excel Pivot Table with Multiple Indexes [duplicate]

I have a spreadsheet where the first 21 columns are dollar amounts received during that month and column 22 is the id of the item to which the amount came from. What I am trying to do is create a ...

**0**

votes

**1**answer

1k views

### How to rectify Excel error “We couldn't get the data from table in the workbook…”

I am dealing with the following problem using MS Excel 2016:
The Excel file contains a huge data table and several pivot tables in separate sheets.
The current Excel file was saved under a new file ...

**1**

vote

**1**answer

462 views

### Using a scroll bar to control pivot table filters

I have created a bar chart using a pivot table. The table has two filters in it to choose with row I am pulling data from. Currently, I can use a drop down menu to change these filters.
But, I would ...

**0**

votes

**0**answers

24 views

### Group by values using pivot table

I am trying to group by some records using a pivot table. Can anyone please help?
Below is my table:
Name Column2 Product Name
ABC XXX Prod1
ABC XXX Prod1
ABC ...

**0**

votes

**0**answers

21 views

### Add a drop down select to a Pivot Table

I have a pivot table of a list of items. I want to be able to add a status column where I can apply a a "state" to them. e.g. "submitted", "cleared", "dead".
Is there any way to do that? I can add ...

**0**

votes

**1**answer

51 views

### How to sort duplicate rows of values into unique rows and multiple columns

Say I have a sample table like this:
And I want to make it like this:
Basically, it is making values in column A unique by moving all duplicate values of each unique row into the next column over. ...

**0**

votes

**0**answers

28 views

### Pivot source with SQL vs. Table source with SQL and then Pivot based on the table

If I want to pull SQL data into a Pivot table, what will be quicker and more efficient?
To have the data pulled into a regular table (which I want to present anyway) and then create the Pivot based ...

**0**

votes

**0**answers

73 views

### Using a “difference from” Pivot field while also sorting the parent row by size

In a Pivot table, is there any way to add a "difference from" field, and also sort the parent row by size? If I try to do so,I get the following error:
AutoSort and AutoShow can't be used with ...