pivottable

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...

I'm trying to copy, create and rename a sheet named "ASPAC CAP" and update the selection pivot table field of the newly created and renamed sheet. The macro below successfully copied, created and renamed the new sheet. however I'm encountering a code error below when filtering the pivot table...

Hi, I would like to be able to filter my pivot table by typing into cell D1 e.g. 111111 This Sub is from me just recording a macro of me manually filtering. Sub Macro2() ' ' Macro2 Macro ' ActiveSheet.PivotTables("PivotTable1").PivotFields( _ "[Item].[Item Code].[Item...

I created a report that pulls raw data from QuickBooks that shows the payments we've received from customers over a certain time frame and gives the detail on the payment itself as well as the invoice the payment was applied to. When we receive separate payments on different days that are...

I am trying to import data from an Access database into a PivotTable Report in Excel. The instructions I have are not matching up with what is happening in the Excel program I am using. I have Excel 365. I am able to get to locate where to import "Get" the data from Access the issue is how do...