pivottable

I have created some code that created a data model based pivot table that just displays a type, qty and concatenated string built from a column of references. This all works fine on the first run. Where it goes wrong is if I run it again on the same worksheet, even defining a different range, it...

Hello Excel-enthusiast, I'm trying to use data, from two tables, in a pivot table. I made a relationship between de referece columns of table 1 & 2, but when I try to add the Weight column to the pivot table it sums the weights for every row? I just want to show the weight for every reference...

I'm trying to copy, create and rename a sheet named "ASPAC CAP" and update the selection pivot table field of the newly created and renamed sheet. The macro below successfully copied, created and renamed the new sheet. however I'm encountering a code error below when filtering the pivot table...

Hi, I would like to be able to filter my pivot table by typing into cell D1 e.g. 111111 This Sub is from me just recording a macro of me manually filtering. Sub Macro2() ' ' Macro2 Macro ' ActiveSheet.PivotTables("PivotTable1").PivotFields( _ "[Item].[Item Code].[Item...

I created a report that pulls raw data from QuickBooks that shows the payments we've received from customers over a certain time frame and gives the detail on the payment itself as well as the invoice the payment was applied to. When we receive separate payments on different days that are...

I am trying to import data from an Access database into a PivotTable Report in Excel. The instructions I have are not matching up with what is happening in the Excel program I am using. I have Excel 365. I am able to get to locate where to import "Get" the data from Access the issue is how do...

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

Good day everybody, New to this forum, first post. I guess this question has been addressed before but I've been unable to find anything in the existing thread. Don't hesitate to re-direct me if necessary. So my question: I have a table, as per below screenshot, recording some consumption...

I have a Pivot chart which has Table in it. I need to add the total to the end of the table. Please help me to get it resolved. Pivot table Pivot Chart Need to add the total at the end as shown down

Hi Everyone, I have a workbook that contains a lot of OLAP pivot tables and so the goal for me is to create a macro that will automatically change the filter known as "month year" for all of the pivot tables in this workbook. The good news is that the macro I wrote manages to do that, but now...

Hi Guys, i want to make excel pivot table slicer generate text in a cell when any slicer is chosen. Is it possible for me to do that? Thanks

Hello world, I have a sheet containing a bunch of PivotTables and graphs. The sheet has an area (B2:F2) where users can input filter criteria which when applied, will automatically filter the graphs displayed to the user. For my data, there are literally tens of thousands of different...

Hi. I'm looking for the simplest way to analyze data stored in a tabular format in an excel sheet and make comparisons (text as well as value fields) using dates as columns. To clarify, I have data for five days spanning over 20 different columns stored in an excel sheet. For each day, the date...

Background: I am "analyzing" data from a large table, for simplicity, I made a dumby excel spreadsheet. My data records races and which place the runner came in. I have uploaded a photo as a visual aid. My goal: To create a pivot table the accurately returns the win rate of the race...

Hi, I've found the below code to display overlapping pivot tables, which will look at every pivot table in the file and then it will pop up messages where the overlapping pivot tables are. Can someone please update the code to make it so I can select the sheet that to code checks (I was...

Hi, question about pivot table FILTERS (see picture) Situation: I erased my source data and my pivotable refreshes correctly as seen in the picture. this happens automatically as I am using a little VBA code in the source data to refresh my pivot tables automatically. However, when you click...

Hi, I am confused as to which formula would be more appropriate for the below problem I am trying to resolve. 2020 monthly payment tab I have a list of participants who give £3 per month and can select a product. They can stop participating at any time. If product A, £1 is allocated to product...

All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......

How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link) # i try excel file create other excel file to particular sheet hyperlink making...... Pleased help me

How to marge 3 table into one table , because i face reference error , i tried......, pleased solving this query.... step by step.