pivottable

How to count "Same Purchase item Qty total" and "minus Same Sale Qty total " if Qty balance is "0" , not show entry in report Again.

Hi - I have a pivot table where columns are counting values from the raw data. However, one of the values that is being counted is "" (aka just a blank / empty cell that is a result of a long IF statement). Is there a way to exclude this value from the count? I tried changing the formula in the...

Hi, I am creating a Glossary for a table with a lot of descriptions of certain activities. I want to be able to type in a cell a value and click the comand button to filter automatically instead of in the Pivot filter. I tried with this code but keep getting an error on the highlighted code...

My pivot table isn't refreshing when I tell it to. Worksheet 1 This sheet has a connection to a SharePoint list. Worksheet 2 This sheet has a table that is similar to Worksheet 1, but has additional columns for calculations. This table is then used as my source for the pivot table, which is...

I'm new to VBA and I dont know how to create a sub that makes a PivotTable Chart appear with a Title, Axis Title, and extended size also. Can anyone help?

I'm trying to write a macro to filter a pivot table based off a cell value. I've adapted the code from this SO post: How to control Excel PIVOT tables from cell values with VBA And this is mine currently Sub Worksheet_SelectionChange(ByVal Target As Range) 'This line stops the worksheet...

Hello everyone, I have a PivotTable with 5 thousand rows. For each row, I need to know their detailed positions. I can use the ShowDetail method, but it's not exactly what I want. It's created a new sheet for each row. Is there a way to extract details of a row into a variable without creating...

Hi, I was given a sheet with a list of projects. It has a start date column and and end date column, and further information about the project (title, manager, budget) are in other separate columns. I have been trying to find a way to be able to select a month and year in a pivot table and have...

Hello, @MARK858 - Is it possible for you to help me on this please. I have a Pivot table, where i need to Select Blank Column next to last row of Pivot table and Put Filter. I tried some coding but i am getting an error. Please help to rectify. Steps: 1. select Row from a Blank Column (Here it...

Hi, all, I'm using: {=SUM(--LEFT(IF(A2:A18="",0,A2:A18),1))} I would like to add an IF function to this formula so it only sums the left of cells A2:A18 IF cells B2:B18 are "108". Does this make sense?

I have two PivotTable fields in the row section, seen below, I need the Trading Partner field to repeat next to the Transaction Set field on the entire pivot table. Below is also an example of what I am looking for. Is there a way to do this automatically so I do not have to do this by hand...

Hi I am trying to get pivot table to show me sales data for a particular store for a each week number of the year. I have my main data in the below format Date Month Week No Day MMM-DD Warehouse Store Sales Values 30/12/2019 Dec 1 30 Dec-30 West Shop 1 20 31/12/2019 Dec 1 31 Dec-31 West...

Hi all! I have a workbook that contains a pivot table, a data set, and several user input pages. I have a macro that updates this data set, and the size of the set may change between each update based on user inputs elsewhere in the workbook. I would like the Pivot Table to update as well...

Hi all, I have a fairly large dataset that is broken down as minute-by-minute data. I am plotting various charts from the PivotTable data, generally using averages. I have "Time" in the row field on my PivotTable, but when I plot a chart it gives me some strange time values along the X axis...

Hello all, I have a workbook with about 10 worksheets. One of the worksheets contains pivot tables and slicers. I would like to check if it is possible share/extract this worksheet with pivot tables on another excel workbook, and that changes will be updated dynamically. Reason being I would...

I have a PivotTable that shows expenses across departments. Each department has a set budget for the entire year. In addition to the grand total that shows how much each department has spent, I would like a column that shows how much of their budget is remaining. For example, the DA department...

Hey Everyone, I am trying to attach a slicer to 2 Pivot Tables based on different data sources. I am following the method as shown in this Youtube video https://youtu.be/p9VD0rsC_bk . I am using it as a guide for my own excel spreadsheet. For my own spreadsheet, I have ticked the box where it...

I have a PT that is created from a Power Pivot table and I want to loop through each item in the 1 column of the PT. I thought the following would workSet ptField = ptPivotTableList.PivotFields("Proper Name")but I am getting a 1004 error, Unable to get the PivotFields property of the PivotTable...

This is the code I'm using:Sub a_Recalc_Pivot_Table() ' Macro to recalculate Pivot Table. ' 2/7/12 Modified. WML ' ' 7/29/19 Copied from "Offfice Development Center". WML Call Initialize_Globals Data.Activate 'Determine the data range you want to pivot...

Hi All, I am receiving this message "A PivotTable Report cannot overlap another PivotTable Report", in a workbook of about 15 sheets or so. Usually when I have this error, I can identify where it is coming from by looking for overlapping pivot tables. I seem to have maybe identified the sheet...