pivot table

  1. E

    Strikethrough Data not appearing in Pivot Table

    Excel Gurus, Lets say that i have a column that has text data (some of which have strikethroughs). When i create a pivot table using that data, the strikethroughs are not coming through. How can I resolve this issue? Eg. Address 1004 N. Josey Ln. 1200 S...
  2. D

    Convert Entire Sheet to a Named Table for a Pivot Table

    Hi guys, I have looked online to try and find some solutions but I keep getting an error. Perhaps I am messing up with the syntax. I want the vba to go to the worksheet titled "Index", and then to convert all of the data on that sheet into a table called "Source" (similar to going to the...
  3. Z

    Analyse Salary Received and Amount Invested Year Wise and Month Wise

    I have 2 table in an excel workbook. 1. Consists of Month wise salary received by an employee for a span of 5 years Date NET PAY Basic Basic Arrears Adhoc Pay 30 April 2015 0.00 0.00 0.00 0.00 30 May 2015 0.00 0.00 0.00 0.00 30 June 2015 0.00 0.00 0.00 0.00 30 July 2015 0.00 0.00...
  4. S

    Is it possible to make pivot table with "%difference to previous" Grand totals with arrows?

    Hi guys. I am building a Pivot which will grow with data each day. I sorted the refresh with VBA, and I did setup my value fields to show values as % Difference from previous day. What I couldn't figure out, how to create a conditional formatting that will add those up/down triangles to my...
  5. J

    Automatically update a summary page from different pivot tables

    Hello, I have a few sheets in an Excel workbook. Each sheet contains a pivot table. I then have a summary sheet that contains columns from each of these pivot tables. An example of the original data looks like this: Time Desc Temp Prg_Freq Meas_Freq Test 1 Test 2 Test 3 1/0/1900 0:00...
  6. M

    Pivot Table - Values as a % of Maximum of Parent Grouping

    I know that title sounds a bit confusing. I have various fees grouped by departments. Customers may only belong to one department, but they may pay one or more fees in their department. I have revenue by fee type, as well as the count of customers that paid each fee type. I would like to...
  7. E

    Using column data to quantify Pivot table

    Hello, I am looking to create a pivot table to track the scrap created by a manufacturing company. Currently the source data is similar to the table below. When I create a pivot table to track the occurrences of "cause" it is only counting the times each cause appears in the table. Is there...
  8. M

    VBA - PIVOT table data transfer to new worksheet

    Hello I wondered if you could help. I have just started to learn how to use VBA to help with data management in excel. I'm using excel office 365 on windows 10. I managed to create a macro that processes the raw data into a pivot table filtered to a set format (lets call this sheet 1). Within...
  9. F

    Pivot Table, Value criteria set to sum, hide zero's

    I have a data source that deals with items going to customer on deposit. If they take one widget, there is a sale of 1, when they return the widget, there is a sale of -1. resulting in a Zero. I have attached a picture. Over hundreds of customers and thousands of transactions, we can be...
  10. M

    Pivot Table: Calculating Average % Across Years

    Hello, I have a Pivot Table with Years as the top-level column, then two fields underneath, Cash and Operations. The values in each field are currently calculated as % of Parent Column Total, so Cash and Operations are shown as percentages of each year's total. I would like to also create a...
  11. B

    Excel data analysis help

    Hi, i am doing a class project for a company i work for that wants to know which customers are returning pails( pails product name in Column "ProdName" as shown in screenshot),and at what rate? The columns I am focusing on is customer name, product name, and removal date. There's thousands list...
  12. S

    How to repeat a single value across Pivot Table columns

    Hello lovely people. I have searched and searched for an answer to this, but maybe I'm lacking the appropriate keywords... either way I'm stuck. I have created the below pivot table, which shows the number of monthly support hours subscribed to by a client (1. Regular), any additional hours...
  13. T

    Pivot table to exclude a row

    Hello, I have a table that looks like the following: Country Element AA 11 BB 22 CC 33 Now, I want to pivot that table to show me the sum of "Element", BUT Country "CC" has to be excluded from the sum (and shown separately in the same pivot table). I created a calculated field defined...
  14. L

    Apply code to all but one worksheet in workbook

    I create a daily summary report each day that includes a pivot table with several worksheets based on filter pages within the pivot table. The pivot table includes a worksheet called "Executive Speeding Report" and "PT". Essentially the Executive Speeding Report worksheet contains the "raw" data...
  15. H

    Pivot table - group and sum specified columns from a single "columns" field

    Hi If I have this table: Name Type amount foo Red 2 bar Red 4 fiz Blue 3 buz Blue 5 foo Orange 1 bar Orange 3 fiz Green 5 buz Green 3 I can produce this pivot table Sum of amount Column Labels Row Labels Blue Green Orange Red Grand Total bar 3 4 7...
  16. F

    Counting streaks from an excel table

    Hi I am trying to track the reliability of vehicles within our fleet, every rota we complete an evaluation of the vehicles where they will be tested on various criteria and scored as a pass or fail (with a fail marking a 1 on an excel table). This data would be better understood by our...
  17. P

    Unpivot Data - Power Query / Excel / SQL

    Hi I have summarized data in the following format: role 2021 2022 2023 admin 1 2 2 I would like to convert this so it is presented as: role year admin 2021 admin 2022 admin 2022 admin 2023 admin 2023 I've tried PowerPivot and the Unpivot option. That doesn't seem to show...
  18. B

    First Pivot Table

    Hi Everyone, This is my first crack at a pivot table and wanted to try to pull specific terms if I can. Let's say I have a thousand lines and want to filter the third column for the most common used words like "list", "purch group", "delist" Basically automatically calculates, what do you need...
  19. W

    Possible for values from one cell to correspond to multiple cells?

    I have a bunch of tasks. Each task requires its own tools, parts, and fasteners. After all tasks are entered, I would like to create a pivot table so that I know what would be required at each station. Is it possible to link one cell to multiple cells? For example, I created a pivot table to...
  20. M

    Completely Remove (Blank) from Pivot Table

    Hello, I have a pivot table with a lot of (blanks). The data looks like this. Level 1 || Level 2 || Level 3 Name1|| Name2 || Name1|| The pivot table looks like this: Name1 (blank) Name1 Name2 I would like for my user to be able to drill into the pivot table without seeing (blanks)...

Some videos you may like

This Week's Hot Topics

Top