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
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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
9 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
0answers
28 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
26 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
22 views

How to add a new month's data in a table when the first column is also changing every month? [on hold]

Let's say that for the month of April I have agents 1, 2, 3 and their sales, and for the month of May I have agents 3, 5, 6 and their sales. Which property should I use to combine both so that I get ...
0
votes
0answers
34 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
11 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
17 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
14 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
42 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
23 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
65 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
24 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
12 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 ...
-1
votes
0answers
15 views

Excel — Find difference of each store's product price and average of all store's

I have a list of product prices in each store (A, B, C, D, E, F, G stores are all selling Apple, Banana, Corndogs, Doughnut, Earrings, Fig, Gums with different prices). I want to find the difference ...
0
votes
0answers
33 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
38 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
49 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
27 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
31 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
40 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
65 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
15 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
28 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
54 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
20 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
80 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
264 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
72 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
18 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
514 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
249 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
23 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
48 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
23 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 ...
1
vote
1answer
67 views

In excel, why can I create a relationship between Table 1 and Table 2, but I can't create one going in the opposite direction?

I have two tables containing related data; both have a Participant_ID column. I've created a relationship between Table_1 and Table_2 with Table_2 as the lookup table. This is so that by setting up a ...
0
votes
1answer
39 views

Display 0 as blank in a pivot table

How can i display a value of 0 as blank in a pivot table. The column I wish to apply this to is formatted as a date. And anything with a value 0 displays as 00/01/1900. I tried conditional formatting ...
0
votes
0answers
23 views

Excel Pivot data sorting by month

I have been trying to find a way to organise and sort the data in a Pivot table in Excel by month, as in the format of the picture I attached to this question, but I have been unsuccessful so far. ...
1
vote
0answers
90 views

Connecting two different data sources pivots with single slicer

I have multiple pivot tables in the same tab from different tab data sources (all in a single excel file). All the pivot tables have a column BName. I want to create a slicer with field BName that ...
-1
votes
1answer
80 views

Excel; How do I import CSV table as rows seperated by table number?

So I have a MASSIVE data set, in its unprocessed format it is a CSV file and contains two column tables that are stacked on top of one another. in the picture below the delimited version of the file ...
1
vote
1answer
91 views

F&B Industry - How to convert 1 Menu into its components with Excel?

I work in F&B industry and I have a problem that my company software could not handle, so I try to manage it in excel. I have a menu that has many components within. So I try to convert the menu ...
-1
votes
1answer
46 views

Making the filter pane in pivot table sorted

Pivot table filtering panes lose their sort order when data is appended to the table which is linked to the pivot table. At first, the sort order in the filtering pane looks nice: But if you haven'...
0
votes
2answers
138 views

Pivot table filter pane is not sorted. Why?

In my pivot table filter, the column containing numeric values is not sorted, while the corresponding column in my data table is nicely sorted. Why? Data: Original pivot: I recreated the same table ...
0
votes
1answer
363 views

Excel chart with multiple series based on pivot tables

I'm starting to learn more about Excel and it's charting capabilities and I have a question to which I can't seem to find the answer. I have three worksheets, each with a single column that contains ...
0
votes
0answers
15 views

How to add a style to Excel power pivot value cells?

I'd like to add a vertical border to columns in a pivot table based upon their heading group. For example, if the heading is grouped by year, and then underneath the year, the values are further ...
0
votes
0answers
55 views

Show contiguous time periods without data in Libre Calc pivot table, pivot chart?

A minimal example: our table has sales in 2015, 2017, but not 2016. Date Sales 01/02/15 $500 10/11/17 $1000 You make a Pivot Table: Data > Pivot Table > Create Row Fields: Date Data ...
0
votes
0answers
33 views

ms excel, pivot tables…how to count the number of times a word/text occurs

full on newbie here...per google, this is the place to ask questions regarding microsoft excel...hoping for some help around pivot tables. i am using ms office 2016 (excel 2016)! so, i am trying to ...