pivot tables

On a pivot table I have categories of inventory and each one has a quantity on the sum. I want to highlight the quantity if it exceeds a limit but the limits are different. So if the sum of catalog codes for the category 'core balloon devices' exceeds 10, i want to be highlighted. But if the...

Hi, I have a pivot table with year on columns and months in slicer. The user can choose the month / months in the slicer and compare it with the different years (years are on columns). Is it possible for the user to switch columns and slicer (via macro?). So they get an overview of each month...

Hi All, I'm trying to use conditional formatting in pivot tables and then filter by color for a set of data. My conditional formatting is working fine but I'm not getting 'filter by color' option in filter. Could someone please help ? Thank you

I am looking to create a VBA macro that has the ability to update one pivot table filter based on multiple cell values. I have successfully been able to create VBA code to update the pivot table filter with ONE value but would like to modify this code to update the filter with MULTIPLE values...

I have searched the Internet to find an answer to this, but have been unsuccessful. My Pivot Table has 7 rows of data whereas the Internet examples only show 1: LeaderType of Unemployment Leader 2 Leader 3 Position Level FT/PT Years of Service This is repeated for multiple Leaders. This...

I'm trying to recreate an existing pivot table and in the Rows window there's a sigma symbol on the 'tile' with the word Values on it. This tile is somehow associated with all of the sums shown in the Values window. If the tile is removed from the Rows window all items in the Values window are...

I have 15 products in Column A with data for each product by specific date in Columns B - AHN. Row 1 contains the dates, Row 2 contains the corresponding quarters, with Rows 3 - 17 containing the data for the Products: A B C D ...

I'm struggling to do a few things with regards to developing actionable insights and presenting in an easy to use dashboard for a wide user group. The situation is as follows; I want to Create a hierarchy dashboard across a number of kpis. I.,e start at the president's view of the average...

Hi all, There are 365 unique values amid the 10000s of rows but I have tried a pivot table then filtered and then double clicked the cell to extract that group to a new sheet which works but I don't want to do that 365 times - or could I automate it? I also extracted a unique list into a new...

Hi there, I'm trying to work out how to create 2 different pivot tables from the one table. Here is an example table below: <tbody> Product Brand Category Jan Qty Jan Sales Feb Qty Feb Sales Mar Qty Mar Sales Item 1 Brand 1 Cat 1 5 $500 4 $400 7 $700 Item 2 Brand 2 Cat 1 20 $50 30 $75 10...

I have a large set of data that I am making multiple pivot tables from. It is basically hours by date. The first table I built was for a summary that I will keep by month. The second is less permanent, but is taking the same data and summarizing by day. I discovered when I went back to the...

Hello, I'm trying to write a macro that will hide pivot table rows if a certain condition is met. What I'm trying to do is the following: - If the Row Label, for instance Google, contains SF and SV under it, then I would like it hidden. - If the Row Label, for instance Apple, only contains SV...

Hi all, first post and not really sure how best to explain so here is a shot... I have a set of data looking at individual education level (e.g. HS, BS, MBA, and PHD) and what concentration for each one (e.g. Chem, Bio, Finance, etc.). If you went to HS, got a BS and an MBA, you would have 3...

Hello all! I tried to search this on the threads, but I wasn't able to locate if this has been asked. I teach a class in Excel. We use Excel for Mac 2016. One of the students upgraded to High Sierra. In the lesson, we do pivot tables and then create charts off of those pivot tables. He went...

Hi, I have a created a pivot table that shows the duration of run times. I am doing an average on the duration but want to remove the maximum value from the average as there are valid reasons for the run time to extremely longer than the remaining duration run times. How do I eliminate the max...

Hi ! I'm working on some macros, in order to automatize a long and boring process, of analyzing data. The first one is working perfectly, no errors, nothing. (I'm just posting it if it can in some ways interfere with the following macros) Attribute VB_Name = "Module1" Sub...

Hello all. I've come here periodically to find answers to Excel problems, but can't seem to find an answer to an issue I'm having now. So I set up an account to ask myself. I've tried searching and playing around with this, but can't seem to find a solution. When I create a pivot table from a...

Hi There, I created a Pivot Table that lists out client information and the months they had software licenses. I have the data below, but would like to sort by month so it sorts by all clients with licenses in Jan, then Feb, then Mar, etc. So what should happen is when this report is finalized...

I have a large data set with many products and product codes that I use to generate several reports, each reporting on a separate group of codes. I set up macros to select the codes, or, more precisely, the VBA behind the macros indicates which codes should not be visible, for each report. The...

<tbody> Column Header 1 2 Row Data a b subtotal 1 X a 2 X b </tbody> I am trying to figure out if i can get the subtotal to show a calculation of the column header and the row data so as to show the subtotals calculating like the table above. I found information on calculated fields but...