pivot table

I have created a Pivot Table to count tickets completed vs tickets completed with a specific code (NLF). It is broken down by location and week within the reporting period. The main point of the table is to calculate what percentage of total tickets were coded with an NLF code, again broken...

I apologize, tried to write shortest possible header Basically I have sheet calls Capped where I got my sql query exported (Columns A:K) Based on that sheet Data I want to create a pivot table I found one macro, but it doesnt work by some reason From sheet Data I need 3 columns. Customer = as...

Hi, I was using a SUMIFS formula to look up an external workbook which worked great. I then decided to pivot table that external workbook so that the data was contained within my file, and users of the file did not need to open that external workbook each time. However, since doing this...

Hey Mr. Excel Boards, So, the short question is that, is there any way to display/add the refresh date to an online pivot table? Long question: I / my boss has built a PowerAutomate (cloud) flow that iterates over a bunch of excel documents in sharepoint, then runs an office script in each...

I have a list that contains DATE PAID, NAME, and MILESTONE #. I want to be able to calculate the number of individuals who receive their milestone bonus on-time and calculate the number of individuals who are not paid their milestone bonus. The milestone is at specific timeframes (7-day, 30-day...

Hi all, I am new to this forum and I have been researched about if it's possible to create many pivot charts without each being generated from an individual pivot table? My end goal is to publish a excel dashboard to demonstrate the price change of different material cost over time. The data...

I am working with a price list and would like to select pivot table fields (column headers) based on the price level (PL) selected which is also a column headers. The price level is indicated by Z0 and Z1. This particular column header can be used or not as part of the solution because there is...

I have a data set with a group of data repeated each year. For example, I have data on schools over a 10 year period. Each school has multiple columns of data. The data needs to be compared for each school across the years to identify trends and needs to be compared to other schools in the...

I have a tab with employee information on it, with the employee ID starting in C2. I also have a pivot table (tab name is 12345 PIVOT) created from another tab with information that I want to pull into the employee information sheet. The pivot contains the employee ID and two types of costs -...

When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. *My Hyperlink click and Jump Sheet 2 "Table 2" (Table 1 location = Sheet 1) My TABLE NAME IS = "Table 1" Range name (B3:B8) = "ITEM_LIST" How to possible This Query ??? Kindly Share...

Hello, I have about have about 3 years worth of sales data and I'm comparing in-store to online sales. I summarized my data in a pivot table and included two slicers to easily click on a year and month to view the total sales for that period. I'd like to use a graph to show a visual of this...

Hi there, I am encountering a problem with Pivot Table in Excel. I am trying to get Subtotal of Distinct Counts, but the manual total of the Distinct Count is different from the Subtotal done automatically by pivot table. In the attached picture of the pivot table, you can see that "Blue" is...

hi guys, i am SUPER bad at pivottables i have this dummy data for a loan here in my sheet: I essentially would like to create a slicer for "Status" that can filter for this table. However, in order to do so, it seems that I have to make a pivottable? I like my current formatting, but if I...

Hello together, I want to show a cumulative division between to columns in a pivot table. A division in percentage between invoied orders and total order. This should be based on the last days of a month. Example given in my first attachment. As you can see, the percentages are wrong...

Hi, I have what I think is a simple question: I have a pivot table with sales broken out into column for E-Commerce Sales and then Brick & Mortar sales. I have many rows of data showing both E-Commerce sales and Brick & Mortar sales. I want to also include a % of total however I am having a...

I'm trying to get a pivot table to return the smallest value from a column called # of Units. The code I have currently is returning zeros with the Min function, how do I get it to ignore zero values and just return non-zero values from the desired column...

Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...

Hi, I have an issue that when I'm working with many slicers I have to wait each time I make changes to my slicers before I can go to the next slicer to make my selections. I wonder if there is a way to work with all slicers before the pivot table refreshes. Thanks

I've got some VBA code in a macro to auto-create a workbook and create a Pivot table (below). The whole thing works like a dream, and throws no errors, creates everything but I can't get it to add the row field to the pivot table. I found the script a while ago and saved it for later use, but...

Hello. I have a worksheet with my raw data on. I successfully created two PIVOT tables on new worksheets. I then deleted the worksheets with the PIVOT tables on because I wanted to start afresh. Excel won;t let me insert a new PIVOT table now. I get the error message "The PIVOTTable field name...