pivot

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

Hi Excel Gurus, After a week of googling, reading and trying. I am giving up to ask the experienced members of the community to please help me out. I am using a pivot chart slicers with dynamic charts with multiple outputs. 1. How do I force the vertical value axis to be the same for each...

I need to use power query to bring the initial format to this format that i have mentioned later, i've tried Merging, Transposing, Promoting Headers and Unpivoting Columns but somehow i'm messing up somehwere. Also need to remove the Random digit values in C column from row 4 to 6. Here's the...

Hi, I have a file which has ~10K rows of data. I want to create a Pivot table removing duplicated values based on the name column this gives me ~2k but I want to capture the data that is derived in a column that contains a tag. The problem is that when the tag is generated there are many...

Hi Team, Can someone help me with the custom sorting of pivot table in google data studio. I have column with data as Jan, Jan actuals, Feb, Feb Actuals etc and i want my columns to be in same order when i put it in to pivot table but it is not. Is there a way to custom sort them.

Hello, I am currently tracking information for a variety of locations. I have nearly 450 different locations that i need to track identical information, I am counting specific equipment and separating it by a descriptive class. For example - at a specific location i would like to count the...

hello all, I am open to suggestion on how to build the pivot table i am after OR just the formula to return the value i need to then try and build the pivot table. Thank you in advance!! I am trying to create a pivot table template that will return a view by name if any area in certain columns...

I have two Data Tables that I would like to combine into one Pivot Table in Excel for Mac. I have Excel for Mac 2019, version 16.54, so a lot of the solutions that are available online seem not to be available for me, such as combining source data into a new table through a Power Query, using...

Hello all, I'm writing this because I am stuck and cannot figure out where 2 issues come from of some Charts I've been working on and how I can fix them. I am using M365. I've been checking for various causes and solutions online in the last few days and unfortunately, I could not figure it out...

This is the source format i have which i have tried picoting and unpivoting and even transposing for some reason to make it work in the format i have attached below i have even reached a point where my excel looks almost like the output but then the batch numbers are missing...

I have a complaints spreadsheet which records complaints over the year by customer, week number/ date, type of product, sub type, the type of complaint, and whether it has been accepted or rejected. The current pivot table works absolutely fine - see attached showing all complaints for type UHT...

Hello- I am having a time trying to find a way to develop a formula to monitor our daily schedule AND actual # of jobs/ work orders that are on our schedule each day, up to each work orders due date. I attached a screenshot of a generic table. We use Air Table to enter all of our Work...

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 really not even sure what the best way to do what what I want is so I'll start by describing the desired outcome. I have a spreadsheet with say 10,000 product names in one column and attributes for each product in a row. Many of these rows are the same product but using a different name...

I just wanted to share a trick I "discovered" for creating a pivot table from a non-contiguous range. I have reports I run weekly from our company financial system to show Purchase Order (PO) Details; one report per active project (unfortunately). I have a macro that formats, replaces static...

Hi, I am trying to sort a pivot but it does not properly work and I have spent hours on it. I sent a screenshot of my pivot. As you can see my pivot is first sorting by Issuer2 in first column which I like. But then I am trying to ask him to sort by total (3rd column) within each Issuer2 which...