pivot table

Hey everyone, pretty new to DAX here so still trying to learn, but I'm curious why I'm getting different results when I use an AVERAGEX function vs the the built-in Summarize as Average function in my pivot table? The source data table looks like this: You'll notice that some of the entries...

Hi I am trying to show the detail on each of these rows (except the blank and grand total row) & rename the sheet to the row label without double clicking each row as the tables can have hundreds of rows. I have tried the coding below but it returns the details of column 2023/001, I would...

Hiya All, I need to set up a sheet to sort out a lot of rows of data into 4 separate sheets based on some of the values. The data is arranged as seen in the table below. I have sorted the sheets for each area but need help filtering the data I paste in. I have a sheet called Paste Data, this...

I appreciate this forum for helping I need help in combining data from two tables into a Pivot table in Excel My data are like given below Table 1 that stores the stops between a start and end. Table 2 that stores how much load was transferred between start and end. I wanted to combine these...

Hi, not having found any answer on the web helping me with this, I make my first post in here... I'm using Excel 2013 on win10, no Power Tools, not IA... I'm making a file with a pivot table that should help me deal with packages or Assemblies, So I have a table/sheet "assembly" with the...

CLIENT SALES DATA CLIENTS DATE SALES AMOUNT CLIENT 4 10-Feb-24 819 CLIENT 4 10-Feb-24 326 CLIENT 4 10-Feb-24 952 CLIENT 3 10-Feb-24 210 CLIENT 3 10-Feb-24 820 CLIENT 3 10-Feb-24 809 CLIENT 3 10-Feb-24 298 CLIENT 2 10-Feb-24 728 CLIENT 2 10-Feb-24 772 CLIENT 2...

Hi, I am trying to get a pivot table to work with multiple columns. This is the data I have: Customer Name Credit Limit Date Sales AA A&A Paper Corporation 3000 2024-03 5,329.50 AA A&A Paper Corporation 3000 2024-02 2,340.00 AA A&A Paper Corporation 3000 2024-01 2,524.50 AA A&A Paper...

I'm trying to make a Pivot table that will sum up filtered data and the filtered data in the pivot table doesn't match the source data with the same filters applied to it. I have two other pivot tables on the same sheet doing the same thing with different filters and those pivot tables have no...

So I have a pivot table and this pivot table is set to averages and the format of mm:ss the same is set in the column that has the data in the table. I could even have one row of 23:01 And it will still show something like 57:42 I do have some blank values that would be returned set as 00:00...

I have a workbook that is helping my team track weekly inventory of something in our lab. We scan one barcode that contains the information required for weekly inventory (Lot ID, Variety, and number of pouches). The next three columns after the scan will split the text by a delimiter using the...

How do I get the distinct count based on 2 columns using a Pivot Table? I did it 2 years ago and can't find my formulas or previous work. Survey response data: Area Responder District School Type Elem Mid Northeast Andy Green School District Washington Elementary School Elem 1 0...

Hello and thanks in advance! I am attempting to filter a date range in a pivot table to the last 365 days of data input. I need the range to be dynamic rather than set dates for the reason that dashboard charts are based on that timeframe. I would prefer that other's don't have to continually...

In my pivot table, I created two columns using Show Values As: % of Column Total. One is Dollar Share and the other is Dollar Share YA. How would I calculate the difference between the two columns and have it appear in a separate column titled, Dollar Share Change? Since I calculated them using...

Names columns Dates column Ok so I have this table that has dates on one side and names on the other. I am trying to figure out how to turn it into a pivot table where I can filter by name so I can add it to the slicer for the rest of my dashboard. I have tried it as the original data and...

Hi Everyone, I'm having a date grouping issue. I can group dates in my Pivot table by selecting all dates. As soon as I try doing it by selecting a single cell it says "Cannot Group Selection." I've reformatted the data multiple times and refreshed the Pivot table. Still no luck. Any advice...

Good evening, I am building a supplier onboarding tracker in Excel and need a pivot table that shows only the supplier names (column F) using the data in column AG. Is this possible or is there an easier way? ABCDEFAG2VNIPACM_IDSM_ID - ARIBATILE SELECTIONSUPPLIER NAMETRR...

Hello, I've been slowly but surely writing/cobbling together code snippets, to gain some pivot table functionality (to be used for "quick and dirty" analysis of fairly large data sets). I apologize in advance for when you see the associated code. I am on a deadline for how long I can work on...

I have a table that is solely populated by formulae. Over the course of time more data will populate this table via the formulae. The Date column does use the DateValue formula. I'm trying to do a pivot table off this table. If I do a pivot table where the range from the table is just...

when creating a relationship between two pivot tables it complains both columns contain duplicate values. at least one of the columns selected must contain only unique values to create a relation between the tables both my tables contain a column called WellId (well name) with the same format...

Microsoft Excel Tutorial: Sorting months in a pivot table when they are alphabetic. I met people who are downloading data from Oracle through Analysis Services. Their dates are coming in as text in the format of Sep-20 for September 2020. When they create pivot tables, the months are alphabetic...