Questions tagged [pivot-table]

A "pivot table" is a method of summarizing data in tabular form. Typically, these have a category column in the left hand side, and multiple summary columns to the right. Each different category will have its own row.

I have a piece of code that looks at percentages as the condition of how it gets color coded. I am wondering if I can add a condition based on another column, then apply it to my effected column.
So ...

I'm trying to crate a pivot table based on a state change dataset that shows the number of times a state changed from one to another.
I'm interested in filling in the gaps where states were skipped ...

The 'Team Name' column changes on a weekly basis, adding more/less team names. The issue I face is that the columns will not be dynamic when pulled into the necessary sheet.
Is there any workaround ...

I'm new to this forum. I need some help with pivot tables:
Question:
I'm trying to consolidate payments Ids together, specifically payments which have the same ID but different payments needs to be ...

Recorded a macro for a report i run weekly that contains a pivot table. The trouble is that the range will not be the same every week. I tried setting the parameters for just the columns but then i ...

Creating a macro that can open multiple files and add a pivot table to each. The files are all formatted the same with the worksheet "details" containing the data needed for the pivot table. However ...

I am using MS Excel 2016 to build some pivot tables using a lot of fields.
When I select a new field, it comes as a "count" and not as a "sum" - so I have to change it manually and there is a lot of ...

I'm working on a management application of an association. In the system, I have an organ table and a member table. The relationship between the two tables is "appoint" in the pivot table. In addition ...

I want to create a pivot table from PowerPivot data by vba.
I have put the year and month in rowfields by vba code, now I want to filter out my data based on specific condition selected by user; but ...

Process:
I recorded a macro to create a pivot table in a new sheet but when I run my macro I am getting this error "Run Time Error 9 subscript out of range". Please assist. My code below. The error ...

I have a form with two pivot tables. One of them works just fine but I can't seem to be making the second one work despite them being quite similar. The one not working is for an image table called '...

I am trying to create an overall sequential pivot of various rows of data, repeating each row as a new set of columns and using the sequence number as the trailing identifier in each column name. Here ...

I have a table where one field shows me the name of my unit, a second field shows a sub category "pillar"(only 3 values that gets repeated of each unit), a third field that has the month of each unit (...

I need to create a formula that takes data from pivot table and the data is automatically update when I drag the formula across in my table (picture 2).
My pivot table looks as below:
My table is as ...

I have the following 3 tables that pull values from a larger table and I need the tables and also the charts to auto sort in ascending order once the master data changes. Screenshot
I got table 1 to ...

I'm having trouble with this pivot table not correctly summing a calculated field when it is collapsed. The field is taking the Standard Hours and multiplying it by the volume.
Is this an issue with ...