Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
0answers
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 ...