pivot tabel

Hi There, I need a calculated field to work out the "completed on time" % in my pivot table. When i do it manually, my formula is =(D5-B5)/D5. I want to insert a calculated field but only have it create one extra column with one result. Thank you,

How can I create a pivot table for each row to summarise each category to do a count of each unique entry as a pie chart? Here is a sample of what each row and column looks like. A B C D E F G H I J K L M 1 Timestamp Email Address Name Date & TIme City, Country Question 1 Category 1...

Hi, I have a pivot table based on data and need to run VBA to format for export to QuickBooks. Below is the table and I need the data from the table on one line with the "j" column for the TRNS line, excluding "i" column. And the same info but with not the "j" but "i" column leaving out "j"...

I am trying to loop through my pivot table to copy the sum values to another sheet. The issue I am facing is, the row variables are dynamic and change when there is a data change, so when there is no variable D or S my loop does not run. Can anyone help me with how to make this work? The...

I am attempting to create a code to create a pivot table on another sheet in my workbook. I am new to VBA and have been using online resources to help me piece this together. The data sheet is Sheet 1 titled T&E I want to run a code that will take the data from Sheet 1 (which is in a table)...

Can anybody help me why calculated field / calculated item greyed out?

I have 15 Row-field (Only Row-field, No column fields) & QTY as data-field in my pivot table. Suggest me VBA code to get all pivot items of previous Row-field for a particular pivot item in last Row-field. For example in below pic for pivot item "TE-118" from row-field "TAG NO", I want to...

Hi all, Currently, I am working on the project with 7 different pivot tables stored on 7 seperate work sheets and the main sheet where i keep data extract. So I decided to use VBA that every time when I update my data extract to automate this process with the help of macros and VBA. I could...

Hi, I need help on creating a calculated column and or measure for any location where the OH is less than 0. I have a table with OH and location in the next column. But I need to list any models where and location has a qty OH less than zero. I want to see all locations OH so I can see if...

Hi Allz, I had help from theBardd to filter multiple Pivots having different sources with one click on a Slicer in this thread. But can any one please help to adjust the following code to link it with a cell instead of a slicer? Private Sub Worksheet_PivotTableUpdate(ByVal Target As...

<tbody> <tbody> Hello everyone; I have question about pivots. I have one excel file which consist 4 sheets. In 4 sheets have more than 10 pivot tables. Every 15 days , my source data is changing(adding new datas) but I have to update new data source one by one manually for 40 pivot tables. Is...

Hi, I'm wondering is it possible to have a power pivot report table that has the details of units sold by one criteria. Then also shows multiple subtotals at the end. IE: Total units sold by Brand is the report. Then I have a subtotals at the bottom listing the season. Another subtotals listing...

hello could anyone help with this please i have a large customer list and I want to analyse which customers are down on spend month by month year I’ve year and show on a graph i can do all of the above but the graph is too busy and it’s hard to see the results- out of the list I only want to...

Hello! :smile: How would I edit this code to reference a dynamic range instead of a specific table? I tried modifying what Record Macro gave me, but did not have any success. Any assistance would be greatly appreciated! Sheets.Add ActiveSheet.Name = "In Program Pivot" Dim tri As...

Hello all, I hope you guys can help me out. I have run into a road block with my excel skills. I have created this pivot table where I wanted to calculate the time that we have between deliveries. I have 3 different type of loads (DC), and I wanted to know how many minutes I have between...

So I have a pivot table that sums how many referral were made in a month for which month. Essentially calculating the number of future referrals. Now I need to create a calculated field in my pivot table that subtracts the referrals made in the same month. Below is what my pivot table looks...

Hi, im having trouble with my code, what im trying to achieve is to automatically select all fields change them to a sum and the format to currency GBP. the reason for this is i have 104 columns of data and the goal is to save time. here is what i have so far, i also need help stitching it...

Hello! Question: Is it possible to have ONE Date slicer for TWO or more, UNCASHED PivotTables, which are from ONE excel table? I have one Table1, from which are two PivotTables(cashed). In first pivot table I have Date grouped by Months&Years. In second I would like to have grouped by...

I have been given the task to maintain a report with multiple pivot tables that summarize Data Source sheets that get updated weekly. The Data Sources have multiple column headers that change (e.g. Oct, Nov, Dec & 9/14, 9/21, 9/28). Thus, every time the pivot tables are refreshed, PivotFields...

I successfully made a macros in excel 2016, for creating a pivot table but I need to replicate the code for excel 2010. Copying over the code from the 2016 version into the 2010 doesn't work and I've also tried re-writing the code, to no avail. I don't understand what I'm doing wrong. Here's the...