pivot table

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

Hi guys, I am currently not able to connect the various charts i have created on my dashboard to the same slicer filter I added. For some reason, Only the first Pivot table shows up when I click on 'Report connection. I have tried to fix it with some of the solutions shared on this Thread but...

Context... I'm working with a very large file but I will simplify it with the following: I have static data in columns a through d (static datal and look up formulas in columns H through H fetching data from a report (report data). The static and report data should reconcile one for one. Columns...

Hi Experts Reference to my older post - VBA to Filter Column Labels using Filter List I got help from one of the experts at the forum. Until recently the below code was working well. Today when I actually needed to use filter I realized the code clears all filter from columns labels but does...

Hi Excel Gurus, I am attempting to set up a spreadsheet where I can update data in tab 1 on a monthly basis, then refresh the pivot in (tab 2). In tab 1, when I paste the new set of data on top (same format), when I refresh the pivot (tab 2), my power query disappears - no data appears in the...

I have a pivot table filtered by "Pozo", showing me those values for each Pozo historically. Next to it, I have a regular table with formulae (referring to the data in the PT) to evaluate the evolution of these parameters up until today, updated daily. One of these formulae calculates the...

Hi Excel Gurus, I have a spreadsheet, two (tabs) are data input manually. I used a power query to format the data. Then I used a pivot table. To refresh the table, I must select "Data > Refresh All" Is there a way to display the last refresh date and/or refreshed by who? for when my pivot...