pivot table

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

Hi, how I can change format of details which popup after double clik on pivot table value? The values on pivot table are formatted, source data also (for example values in pivot and source are two number after decimal but after double clik on pivot pop up details without formatting different...

Hello, I don't know how or with what this report was originally created, but I'm using Excel and a pivot table to recreate it. I want the description to be displayed in full like the second picture. Attached is my recreation and the original. Is this possible using a pivot table? (Blue Tape...

I am trying to graph attendance over time for a large number of events. This data is presented by week, so I have attendance per week for each event. The events take place in multiple locations, so I want to be able to see how attendance compares at each venue by graphing the lines on top of...

Good morning, I've searched everywhere, watched Youtube videos, and haven't had any luck finding what I need so I figured I would go to the experts of Mr. Excel to help me out! I have a pivot table in tabular format with all item labels repeating. I have 2 different rows and am trying to sort...

Hi everyone, I’m new to this forum / VBA and I’m trying to create a code that applies conditional formatting for all columns in every pivot table and refreshes every table in my Excel workbook. I’ve been able to set this up for one pivot table / one sheet but I’m not sure how to change my code...

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