pivot

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

Is it possible in the file I attached, before creating a pivot, to create a pivot only from a specific range? I particularly mean the range from the date to the "SHIFT GEGINNING DATE". Preferably using a window that would give the possibility to enter the date from - to using the...