pivottable

Hi all, I am fairly new to PowerQuery. I have 3 columns, each one with a Table (all tables have the same structure and number of rows): When I expand Column 1, every row of the expanded table gets a table for Column 2 and 3, So I get a big number of duplicates. Is there any way I can...

I have tricked a pivot-table to search in value fields and item-fields like a manual auto-filter. I did this by applying a manual Autofilter on the Pivot Table by using this solution. Now I can filter all columns like a regular AutoFilter which simply hides the rows during a filter instead of...

Excel Version = 365 OS = Windows Hi Everybody, Still New to the whole Power Pivot thing so please bare with me as I will have a lot of Obvious Questions that might seem stupid. Summary: I have Engineers that work on Work Orders, Each Work Order has a Start Date, Start Time and a End Date...

I'm looking to apply a filter to a PivotTable using VBA but I'm stuck on what I hope is a simple error on my part. The source of my pivot data covers ~10000 rows of data, and the column that I'm applying the filter to is called "Mapping Code". I am looking to filter this part of the pivot to...

Hi I work for a preschool in the UK and have developed my own spreadsheets and learnt how to insert pivot tables to run a number of reports. I am stumped though. I run a daily breakdown of children and staff so that we can ensure that we are staffed in the correct ratio of adults to...

Fairly new to excel. I have created a pivot table and organised it to display what I need. When creating a pivot chart, when I create a slicer I cannot filter the data/rows I want to view. It may be that I need to add something to the raw data or that I need to change my pivot table/chart...

I'm learning to use PivotTable and I'm attempting to create calculated fields and change them to counts or sums, but it's greyed out? No matter which data source I use, how simple the calculation is etc. I wanted to change Sum to Average, so to get average profit and average cost per age group...

Hi all, I have this data sheet: I have turned it into percentages and I assume that the top value (0.36% & -1.52%) are the sums of my columns (I am very new to Pivot, sorry). But I have #DIV/0! errors! :( Is there a way in which I can implement an IFERROR formula for my entire pivot table...

Hi All, I am currently facing an issue in with my pivot table that I have been absolutely unable to fix and it does not seem like the Power Pivot forum is very active compared to this one. In addition, mine is more related to Pivot Tables than Power BI, Query or anything like that, so I may...

Dear all, I have currently made a pivot table, which I am linking to some Power Query data. The data in the power query comes from a folder where I import files from a website, so these files will ALWAYS have the same file name, sheet name and column names. However, the data under their...

I would like to know how to copy a variable cell value in a pivot table from one sheet to another. I would like to copy Sum X Est from label Buy and S. The code must work even if there is a row missing of data. I tried GetPivotData("labels", C1, "Buy", R2, "S", R3, "Sum X Est.", C2) but it...

Morning All, I'm trying to avoid my dozens of pivot tables date groupings being lost in the event of a date being accidentally left blank in the source data. I've been toying around with the PivotTableBeforeAllocateChanges event but have had no joy, it just doesn't seem to work. As a test I...

I'm trying to covert a table of data into a more usable format - currently the data is laid out like this, with the hours for each resource broken down by task as shown below: Task Name Resource 1 Resource 2 Resource 3 Resource 4 Resource 5 Resource 6 Task #1 6 10 3 Task #2 8...

Hi, I have a problem getting two tables to work together despite unique relationship. The table 3 has a column (date) which is unique. The Table 1 and 2 have also dates but not unique. When building the relations between these it works fine, but when i excel trying to use these data in a pivot...

Hi all, Using Excel365 My code is retuning an error Not sure why? I am trying to add 4 Row Fields to the Pivot Table. The first 3 are added to the Pivot, but not the 4th. I see the column in the data source I can manually drag the field from the Field List to the Rows Fields Not adding the...

I am trying to build a more agile and time limiting financial reporting tool. In this proces I stumpled upon a problem that I can't seem to fix. I am trying to get Year-to-date numbers by referencing a range of cells containing Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep Formula that works for january...

Hi all, Using Excel 365. I highlighted my data >> Insert Pivot Table >> Add this Data to Data Model. I added fields to Page Filter, Filtered for a vendor I added document # to Rows and Distinct Count of Type to Values There are 44 Document #'s and the Distinct Count of Type for each Document...

Hi, I am hoping one of you fine people can assist, I am using VBA with a data model to draw Pivot Tables (the data is loaded to PowerQuery Only and saved as a connection). Drawing the Pivots was fine once i got my head around the nuances of CubeFields with the help of trusty WiseOwl videos...

I have created some code that created a data model based pivot table that just displays a type, qty and concatenated string built from a column of references. This all works fine on the first run. Where it goes wrong is if I run it again on the same worksheet, even defining a different range, it...

Hello Excel-enthusiast, I'm trying to use data, from two tables, in a pivot table. I made a relationship between de referece columns of table 1 & 2, but when I try to add the Weight column to the pivot table it sums the weights for every row? I just want to show the weight for every reference...