pivot tables

  1. 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/
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. M

    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...
  9. 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...
  10. 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...
  11. 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...
  12. 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
  13. 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...
  14. 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...
  15. 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...
  16. B

    Pivot Table Filtering

    Hi All, I'm looking for a way (if possible) to allow my filters in a pivot table be based off of an "if" statement or something similar. The data that i'm pulling from is a little complicated to write out... but here goes nothing. I work at a hotel and every night there is a snap shot of what...
  17. C

    VBA Pivot Items

    Hello, I'm trying to automatically set the current year and next year in a pivot table using VBA. This is what I have currently Dim CurrentYear as Variant Dim NextYear as Variant CurrentYear = Year(Now()) NextYear = Year (Now())+1 With ActiveSheet.PivotTables("PivotTable1").PivotFields("YR")...
  18. A

    Using Power Query Connections in Pivot Tables

    I use Power Query to massage data from a number of sources. It works great. There are cases where to create the right analysis that I use pivot tables. When I create the pivot table, I select External sources and select the appropriate Query as input. Everything so far works great. The issue...
  19. O

    VBA Code for Pivot Table Sum Field Invalid Qualifier

    Thanks in advance for anyone's suggestions. I will give feedback on any suggested solutions. Why am I getting a "Compile error: Invalid Qualifier" on "xlDataField" within the line: 'Add item to the Data Field to either Count or Sum. In this Case Sum With...
  20. N

    Colour Pivot Filters When Active

    My goal is to highlight the cell when I have a filter active in the pivot table row & column labels. I have found the linked document below which shows me how to accomplish what I'm looking for in regards auto filters. What I would like to do is perform this same action in a way that functions...

Some videos you may like

This Week's Hot Topics