pivot

Hi All, I have a pivot table aggregating quarterly data of number of employees at multiple sites. In order to analyse this, I need to know the average number of employees in each quarter to use in an injury rate calculation. I am trying to use a calculated column in the pivot table but this...

Hi, I've just started trying to use pivot tables. I surveyed some students using Forms and have downloaded the results. One of questions was "how do you rate the following in importance" Job Security, Co-workers, Public Facing, etc etc. So assentially they had 10 questions that they could...

Hi everyone. First post here, so please let me know if anything is not according to the guidelines. This is a snippet from a table in which data is collected from the brewery I work at (not all columns are depicted): batch # tank numberbrew dateempty...

Full disclosure, I'm not a pivot expert - I created this table attempting to replicate a Crystal Report, and while I've been 99% successful there's a big formatting issue - the fund numbers keep repeating when I add a new column. The columns where this issue starts are calculated fields. I'm...

I have a large spreadsheet containing multiple pivot tables. Something in the spreadsheet (I assume a pivot table) is pointing to a file that doesn't exist anymore. When I click Refresh All to update the pivot tables, I receive an error "Sorry, we couldn't find <path and file name of the...

I'm sure this is an easy one, but I can't wrap my mind around it. I have a data table like this (sorry for the image, the XL2BB macro isn't activating for me) Here's what I'd like the pivot table to summarize for me: the number of Pass's and Fail's each student received on each date. Just...

I often have to copy data from pivot tables in order to make sales reports later. In the pivot table, my data is structured according to the following hierarchy: Brand name-season-category How can I copy the data from the pivot table so that the data is like in a regular table, but the...

I work as a sales data analyst for a clothing manufacturer. And I often make sales reports that are structured by Brand-season-Category. I constantly have to manually select rows and group data. Maybe there is a way to write a macro to do this automatically ? A macro with constant strings will...

I´ve a problem with one of my pivot table. I can´t really post the excel since it contains sensitive information but i´ve attached an image of the problem. The problem is that dates from my raw-data sheet is displayed twice in my pivot filter section. There is 10 cells with information but 20...

I am currently looking to calculate a savings percentage. To do this, I have created a pivot table that adds Column A- All of Company A’s billed costs. Column 2- All of Company A’s reviewed cost savings Basically, there is a review process and column two has what we were able to reduce based...

I have a GSheets pivot table that shows me tag usage and the dates used, there is no need for columns I simply have rows defined for tag and date used. This gives me the list I need (almost). I want to find the first date of use, so the second column of the pivot shows me all dates use and the...

Hello. I have a pivot table showing monthly revenue for fiscal year beginning Jul ending the following Jun. How would you add a calculated field to show projected year-end total based on Jul-Sep total, plus the projected revenue from Oct to Jun, based on the Sep value, assuming the Sep value...

Guys, here's my issue.... I have this data grid that I need to pivot it. Simple. The problem is that the dates comes across (toward the right) of my main columns. Usually, I'd rearrange my data in a vertical rather horizontal direction BUT It cannot be moved as per client's request. Well...

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

Hi, I am add a simple sum calculation to a pivot table which will multiply column 1 with 2. I have added a calculated field with the following formula ='Unit'*Quantity However i have noticed that a lot of the totals are showing incorrect. Is there a different method to calculating this? Thanks

Hello, i have a question for a practice interview test which is On the ‘Workings’ sheet use formula and/or pivots to analyse this dataset to identify the percentage of students still retained and graduated at the end of the third year (by course) and the proportion of graduates that received a...

How do I add a goal line if I have more than one column? It keeps duplicating the goal for each column. I only want 1 goal. I understand how to add a goal line by going to PivotTable Analyze-> calculations->Fields, Items, & Sets->Calculated Field- Name and forumula I havent changed the...

I have been searching a solution and cannot seem to find one, is this possible, What I am trying to do is write a macro that will create a pivot table onto another tab. The sheet that the data is on is titled with a customer reference number which changes from workbook to workbook. Is it...

Hello I am trying to calculate and then chart the difference between dates in a pivot table and I could use some help. I have a list of dated transactions for various customers and I am trying to find the time elapsed since the previous payment so that I can show it in a stacked column chart...

Hello, I run a lot of macros that have one big table as an input data, that is later tranformed into separate tables by making pivot tables (using different column/row sets and usually different filter). Since my upgrade from Office 2016 to 2019, all of them started to work very slowly. I...