pivot tables

Hello, I am attempting to create a pivot table to view how sales trends have changed over time. My data appears as below. <colgroup><col><col span="3"></colgroup><tbody> Description Period Units Sold $ Sold Blue Week 3 15 $55.20 Red Week 3 12 $48.19 Yellow Week 3 9 $62.00 Orange Week...

Please help! I am having a huge issue with the Show Items With No Data Option. My Subcategories are tied specifically to their respective MainCategories. MAIN1 has SUB1, SUB2, and SUB3 MAIN2 has SUB4, SUB5, and SUB6 MAIN3 has SUB7, SUB8, and SUB9 Not all SUBs have data in them. My expected...

I have a Pivot Table which was created by another user (no longer contactable), as well as the source data, located in a single workbook. The source data is an Excel Table. The Pivot Table contains two extra fields that are not in the source Table. The two fields appear to be predefined...

hi all I have put 3 pivot tables on one report which are created from a query with criteria to input to and from dates which work however when I run the report it asks me to enter the dates about 15 times. my questions is this... is there away I can link the criteria question so the I can just...

Hello, I am beginning to make a dashboard with multiple pivot tables. A few pivot tables will show details by date so as the month goes on the pivot will grow with each date. I need to keep the pivot tables one below the other to keep formatting can't put it next to the other. I need to keep the...

I currently have a column of data that is formatted as "MM/DD/YYYY 0:00". I have been formatting it to "MMM YY" by using the formula "=text(cell, "MMM YY"). This accomplishes my task, but them the columns are sorted in ABC order instead of date order since it is a text and not a date field. I...

I currently have a workbook designed that uses data from several reports within our POS system. The problem is I have to run reports and export to excel, merge some reports so they are in one clean table, then copy and paste into my workbook. From there my pivot tables automatically refresh...

Hello, I have a series of daily data for a series of employees and some employees have no data on certain days. Is there a way that I can average the data in a pivot table without the pivot table recognizing the blank cell as a 0? I do not want to assign a value to the blank cell, I want it to...

Hey guys, I'm sure this is possible, but I've had quite a time trying to figure out how to do it. Any help would be awesome. Currently this is basically done manually and it's very time consuming: I know there is a better way. I'll describe a simplified version of what I need below, and then...

Hello there, My company uses a SQL server to store large amounts of data and I've built several dashboards that use pivot tables linked to the database. Lately on a few of my files I encounter this error and then if I select "Yes" then all or some of my pivot tables are removed and revert to...

Having a pivot table, I need to apply a filter with 1) a specific date and 2) data sets without a date. I have tried the makro but it stops at " .PivotItems(i).Visible = False" in the first loop where i=1 Sub YesterdayBlank() ActiveSheet.PivotTables("PivotTable2").ClearAllFilters Dim...

Hi All, I am new to VBA, and am looking at ways to have pivot columns show up, based on a data validation list - so that the user can select a location in a cell, and then the pivot table updates to show only the column related to that Location. The locations are set up as columns in the...

Hi, I have a pivot table in my spreadsheet. I would like have a macro that when run will update the date in the pivot tables according to what is in cell C4 and C5 in the sheet. So after the macro is run, it will have selected multiple dates in the pivot table (in this case the two dates...

Hi Everyone, I'm new to VBA and have created a database file which, thanks to lots of helpful posts on this forum, as well as Google and YouTube actually does what we want it to do! I'm coming unstuck by a small, yet annoying, problem however. Upon opening the file users are met with this...

Hello, I am trying to figure out some details in modifying data in my Pivot Table. Here is a sample of data I have. <tbody> Course Name Start Date Location X Executives Managers Supervisors How to.. 12/12/16 123-K55 X 1 12 2 </tbody> Now what I want to do is for the system to know that...

I have created a pivot table that will show total sales for our company by salesperson grouped by year and then month. I have it set up the following way: Total Sales as the Value Sales Rep Name(s) in the Column Labels Years, Date of Sale, Contract Type in Row Labels I have a salesperson...

Hello. I need your help. This is how the single email is sent: On the tab "Email", there is a slicer and a series on pivot table. You select the name in the slicer and the information will change in the pivot table. After this change happens, you press a button and it will email the...

Hi, I work in marketing and am struggling with being able to do a pivot table due to the large number of fields and different titles. However l know what l want my end point to be. I have streams of data like the below and am basically wanting to be able to set thresholds to form the...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> For years I have been filtering multiple pivot tables in a worksheet with the same field names but different data sources, arranged vertically, by applying column filters. I now...

Hi everyone, I've got a problem where my solution just isn't good enough and I'm hoping someone will have a better idea. The problem: I have to report vehicle utilisation by month, by region, and by "category" (front line, second line, specialist, and average). I need a line/bar graph that...