pivot table

I perform a vlookup command on a pivot table. Results are not same as I expect. Is there any limitations for performing vlookup command on a pivot table? And very oddly when I perform isnumber command and numbers in pivot table, the result is: FALSE. I have to add, Isnumber returns FALSE for...

Hi everyone, Could I get some help with my formulae. Below is my pivot table I created from a data source. I defined this as PivotTableRange under sheet called Data - Pivot using =OFFSET('Data - Pivot'!$A$1, 0, 0, COUNTA('Data - Pivot'!$A:$A), COUNTA('Data - Pivot'!$1:$1))...

One way to display text in the values area of a pivot table is to use conditional formatting with a custom number format. Unfortunately, Excel scripts currently cannot apply this kind of feature to pivot tables, only to ordinary cells. On the other hand, good old VBA can do it. So, this is a...

Hi all, I am trying to add a timeline to my spreadsheet to allow users to adjust the date period that they want to see data on. I will try to break down how my data is being constructed: Workbook has 2 sheets. Dashboard & Sheet1. In Sheet1, I have a table named WIP_RAW which is pulled from a...

Hi everyone, I'm struggling with transforming a complex Hierarchical Table into a format suitable for creating a PivotTable. The existing data structure is proving challenging to work with. Current Data Structure (example): Level 04level 05level 06level 07level 08level...

Hello, can I ask for help your help. I find it hard to solve the percentage of Lost Calls by date and language. Please see sample below: . below is a sample data, for reference. Wait Time Name Status Call Duration Language Class Date Offered 12/2/2018 00:23:20 00:00:41 LOST 00:00:00...

I inherited a report from a colleague who passed away recently and I've hit a roadblock while trying to update the data. The report has quite a few pivot tables and a good portion of them reference a table or worksheet called "All_Data". Problem is I can't find the table anywhere. The workbook...

Hi I have a pivot table with several UNITS (unit 1, unit 2, unit 3… etc) in rows and then in the columns I have different cost points for each unit. Last row is a calculated field SUM OF ALL COSTS. In second sheet of the same document, I pull the unit name and total cost of each unit to create...

Hello, For certain products, we have a variable pricing concept and through a power pivot table we're trying to determine - by product (row) - for every sales price (value) the mean, deviation from mean and standard deviation. We use measures in the pivot table to come to the standard deviation...

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