pivot tables

  1. M

    Pivot Table - One Part Shipped to Many Locations

    We ship parts to multiple locations. I'm trying to see parts by a specific location (easy), and at the same time see the other locations a specific part ships to. So far all my efforts have been self-defeating because of the initial filtering by location. An easy example: Part Number...
  2. R

    What is the most efficient way to solve this both the problems and are there multiple ways to solve them? Please let me know. Much appreciated!

    I have tried solving the problem Q1 and Q2 and I am getting errors. I have attached the images with this. PS- Q1 and Q2 are the questions. Tab1, Tab2 and Tab3 is the data I have to work on. How do I got about the same? Please help me out. Thanks!
  3. tomsov

    Combining sum result from multiple tables

    Hello, I'm struggling with a combined table result issue as follows and I'm hoping someone can help. I've got 5 seperate sheets, all with named tables that are exactly the same format - the tables refer to customer orders that contain the same data - so order live/dead, order number, part...
  4. O

    do not allow moving/selecting/editing pivot chart but allow the user to use the filters of the pivot chart

    Hello everybody, i have a chart (created from a pivot table) and i want the user to be able to use the filter on the chart but to NOT be able to edit, copy or move the chart. Is this possible??
  5. J

    Grouping Pivot Table and Slicers NOT working

    I have been trying to figure this out all day: I am building a dashboard, and I have everything in a summary tab (in a table) to pull for pivots. The dates do not seem to be recognized as dates when I try to use a pivot to group by date. I have tried text to columns, and formatting cells. I...
  6. alansidman

    Want to Put Text into a Pivot Table instead of numerical data

    Have you ever wanted to put Text into the fields in a Pivot Table instead of Values. Well, I found this link where Bill Jelen shows you how using Power Pivot at the site Strategic Finance. Fairly easy to follow. https://sfmagazine.com/post-entry/ju...a-pivot-table/
  7. S

    VBA function fail w/Pivot tables

    The question I have is why this code simply toggles between showing and hiding the Sales Date pivot field. It’s only supposed to hide the Sales Date pivot field when the cell M11’s value is “Weeks” but it seems like it’s ignoring this second condition of the if statement. M11 is a pivot row...
  8. P

    Pivot Table not being created by VBA Code

    I have been struggling to create a pivot table using the following piece of VBA code, but I cannot find the error. I assigned a watch window to PT2, and I noticed after I set PT2 equal to the PivotCache, PTCache2, PT2 still appears with a value of nothing. The With Block does not work because...
  9. P

    Pivot table only picking up random parts of source data

    Hi I've created a worksheet which has two pivot tables drawing from the same source-data. So the pivot tables - both - are not reflecting the correct data. So I clicked on 'show details' - which of course - brings up another sheet showing the specific filtered data being used. The filtered data...
  10. C

    Pass/Fail rate calculation in pivot table

    I am looking to add a measure for my pivot table that will do a simple pass fail rate calculation. The calculation is =pass/sum(pass, fail) how do I translate that into pivot table language? There are 4 basic criteria I am working with. Inspection ID, Date/time, Eval Area, and Rate Status. The...
  11. S

    Help with Pivot Tables

    I have spreadsheet with the performance data of 50 search engine search terms across multiple ad campaigns in Google and Bing. For each of the data columns below, I would like to create a formula I would use to aggregate the data in a pivot table: 1) Impressions 2) Clicks 3) Click-Through Rate...
  12. C

    Pivot table conditional formatting, from another sheet?

    Hello, I have a table with many rows and columns. Each row represents a course a user still needs to complete. The row will have the user's name, and a bunch of other columns, including a "People.Temporary" column which indicates if the user is a temporary employee. If the user has more than...
  13. MrDB4Excel

    sort two columns, one from each of two sheets

    I have looked and do not find a solution to acquire one column's data, insert it into a new sheet. Then acquire another column's data from a different sheet and enter that into the same column that the first column's data was inserted. This way the data from two columns, each from a different...
  14. D

    Help me Excel Community

    Hey Team, I've developed a dashboard but have come across one error and I am hoping someone out there can help me! By using VBA code, I have columns which allows for multiple items in a drop-down list e.g. column A has the option to select Apple, Orange, Banana. Is there a way to produce a...
  15. S

    "Add Measure" Isn't Coming Up (even after I select "Add Data to Data Model")

    I am trying to have texts in a value field in a pivot table, and my understanding is that creating a Measure (concatenating the text) is the best way to do so. However, I am unable to create a measure when I am in the Pivot Table, as even after I select "Add Data to Data Model" when creating the...
  16. S

    Copy table and paste to next empty row

    Hi I have a pivot table on sheet 1 and would like to paste values to the next empty row on sheet2. I need a macro that will select everything but the header on line 1 and grab the data on the table and paste to the next empty line. Thanks. This is what i have so far, but it writes over the...
  17. Tommy2Tables

    Equivalent of Sigma Values for pivot tables in LibreOffice Calc

    We have volunteers who won't spend the money to get Excel. But our training comes from Excel things. For pivot tables, Calc does not have a Sigma Values to set up. What is the work around? Thank you. T2t
  18. B

    Pivot Table Retained Items & Refresh All

    I have a spreadsheet that updates based on a user-entered date range. I'm running into two problems. 1. There are some values I need to exclude from the pivot tables. For example, the number of rows of data will change depending on the date range. I have index match formulas where I set the...
  19. D

    More Table Option - Pivot Table Fields

    Good Afternoon everyone, I’m currently struggling with an excel feature. Whenever a pivot table is created and the pivot table fields open, there is an option under the fields column called ‘more tables’! I’m wondering how can I add that again. I updated my Excel to the most recent (2016) and I...
  20. F

    PIVOT TABLE Values not Matching Worksheet Values

    Work Day values in the Pivot Table do not match the work day values in the worksheet. Some entries in worksheet show less than a full day (e.g: 0.75 of a day vs. 1 day). I tried to use the cell format function the Pivot Table, but that did not work. How do I get Pivot Table to show values < 1...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top