pivot

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

Hi all, I have a pivot table based on stock levels over multiple weeks, most of the fields work as expected (transfer in/out, etc.) but one I'm having trouble with is 'Opening Qty'. The issue is that this field sums the 'Opening Qty' from each individual week in the range when I actually I just...

Hi All, I can define columns and data for required columns and So on for dynamin range But how do i convert it into complex charts in the excel file under Tab "Chart Data" Can anyone advise Now there are 2 questions here Can i create a chart where i can ignore blanks and N/A so my data can...

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

Hey, I have an excel table with invoices. Invoices has two dates, one is the date of completion, the other is the date when the invoice was actually paid. I need two different charts from this. One that shows revenues according to the first date, and one that shows revenues according to the...