pivottable

Currently having trouble with opening a document I've added several Pivot Tables to. I've did similar work to another document a few weeks before and that continues to run without issue, being updated on a daily basis. This new document is layed out nearly identically and everything is formatted...

Hi everyone, I have a problem with this code: Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Dim ws As Worksheet Dim pv As PivotTable Dim pf As PivotField Set ws = ThisWorkbook.Worksheets("Atleti e Media") Set pv = ws.PivotTables("PerATleta") Set...

Hi, I have an excel file where employees can submit projects they are working on and amount spent on the project each month. The names of the months are therefore in the columns as headers. When I make a PivotTable out of the table I have the persons in the Row sections and the month I want to...

Hello, I've been struggling quiet a lot with this issue and been looking high and low but I'm not able to find any answer. Hopefully some master can help me solve this issue! I have two table, lets call them Table1 and Table 2 in Power Pivot. They have relation to each other through Column...

Hello excel experts, In a PivotTable, are you able to have current/prior month in columns automatically/dynamically? Currently I have to select the months manually and move them in correct order. Secondly, is it then possible to have variance in columns? See picture for example.

Hi I am trying to work out how to make a pivottable that counts how many members are in each group that exist in each club. Names are the members of each group or club. The pivottable in the example is to give you an idea of what I am trying to work out. I have tried using Data Modal but it...

I have the following code that show details of a filtered PivotTable in new worksheets. I want to create new PivotTable in these new worksheets and have the following code but I keep on running into the object required error on the Set Tbl = d.Parent.Cells(d.Row, lCol).Name line? How do I fix...

Hi Everybody, Goal first, then my problem. My goal is to use the PivotTable to display the Vendor & PO# in two columns such as this using the following formula in my Pivot Table: =CONCATENATEX(Table1,[PO#],", "): Vendor PO# TopCon Medical 612-A2561 My problem is that when I try to move...

when creating a relationship between two pivot tables it complains both columns contain duplicate values. at least one of the columns selected must contain only unique values to create a relation between the tables both my tables contain a column called WellId (well name) with the same format...

Hello, I would like some help making the following Pivot table in a "power query". I have attached the final version of my file. Transpose is necessary, but due to too many titles, I couldn't. Picture of the table below. It will make the job much easier and simpler in a situation like the...

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

So I have PowerQuery cleaning some data and splitting it into different work groups. Works a treat, saves me mucho time and effort. But I am now getting greedy and want to push it further. Can I get PQ to: Split this into different workbooks instead of worksheets. That is rather than, say, 10...

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 all, Really need help since I can't solve it by myself :( I am not familiar with VBA and most of time I just try and error or search how other people write the code.. but i am stuck here. I have 4 pivot tables (ABCD) in the same sheet and connect to 2 different data sources. There are 4...

In Excel 2016, I have several PivotTables (and corresponding PivotCharts) that use external data sources. The data sources were created via Microsoft Query (an Excel mechanism) and have complex SQL logic that queries an Oracle database. For certain PivotTables, I want to change the data...

Hi, I have many tables and I would like to find out the best way to count the number of units sold that meet a criteria. In tblInvMaster I have a fields called PROMO CODE. I want to sum up the number of units from tblSALE that have a PROMO CODE. So I can use the related function in DAX...

Hi guys, I have two tables: Master Table: contain the list of all customers we need to monitor the sales Sales Data: we update it every week with year to date sales for the customers in the master table MASTER TABLE SNIPPET Customer ID Customer Name 12345 Customer 1 12346 Customer 2...

I need to ask if it's possible to match value from pivot table item with value in another normal table and return the value from another column. Example: I have this pivot table with this "account" id slected and in 2nd worksheet i have this table And i would like to know if it is...

Hello i need loop through all "accounts" item in pivot table, and select one by one and save to pdf file the account statement for each account. I have this code Sub pivot_tables() Dim p As PivotTable Dim pf As PivotField Dim pit As PivotItem Dim pit2 As PivotItem Dim saveLoc As String Dim...

Hello, I have a simple pivot table with name of a product and sum of sales in year 2021 and 2022 shown as procent of the total column). Im trying to add a calculated field that would show the diffrence between the two years. For istance in 2021 sales of apples was 15 and grand total of sales of...