pivot

  1. M

    Simple Pivot Table Help Needed!

    Hi, I'm fairly new to excel and I'm looking for a way to create a pivot table that does the following: There are 3 companies, and each company has 3 categories. Each of those categories has a number of impressions associated with it. I want to make a pivot table that sums categories 1 and 2...
  2. M

    VBA Pivot Table Errors

    Hi all, I can't seem to figure out why this code is not working to create a pivot table. I'm using Excel 2013 and will be updating to 2019 soon. When I get to the last line of code, I get Runtime Error 5: Invalid Procedure Call or Argument Sub Auto_Pivot() Dim PBook As Workbook Dim PSheet As...
  3. P

    Summing by Quarter (dates are in header row)

    Hello Experts, How can I sum this data by quarter? Dates are in row 1 as a header. I would like to have a pivot and date filter and sum by quarter but I seem to remember that having dates in a header row creates issues. Beneficiary Issuing Entity All In Rate 4/1/2020 5/1/2020 6/1/2020...
  4. B

    Week over Week Change for tickets that are Open, Resolved, and Pending

    Hello I need help setting up a weekly report table or pivot that shows the number of open, resolved, pending, and new added tickets. The new data for the report comes out every Monday morning and I will send my report every Monday afternoon showing the number of open, resolved, pending, and new...
  5. J

    Need help with a percentage calculation in a pivot table

    I'm working in Excel 2019 on a pivot table that has two rows of data. The first is the Employee and the second is the Warranties they've sold. The values show information like the # of warranties sold, the total amount sold, etc. I'm looking for a way to calculate a % for each Warranty for...
  6. nburaq

    VBA or PQ or Formula or Pivot Table?

    Hi Gents, I would like to compare two sheets having 3 common dependent in each sheet and would like to see the difference at another sheet or in sheet2 specified column as "Difference" I tried Pivot table and xlookup but didn't work for me and I think this one needs VBA or PQ. I even don't know...
  7. E

    Pivot table - display items with no data

    Hello, I have a problem... I want to make a pivot table with multiple items in the row section (projects, revenue-type, and 2 more), together with a filter (revenue-type). I then want to display all values (including items with no data) from the project list, in other words the first row...
  8. R

    Calculate a remaining balance through pivot chart

    Desperation brought me here, as I'm banging my head against a wall trying to figure out why I can't insert a calculated field or item that would allow me to show a running remaining balance for vendors using a pivot chart. I've attached an image to show the basic set-up I've got. Ideally the...
  9. E

    Is this possible? Adding equations and formulas to pivot tables

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

    Excel VBA Pivot Table and Graph

    Hello, I am really struggling right now. I have to create a pivot chart with "Industry" as a row field and "Count of Industry", and "Sum of Current Equity" as values. I then have to make a pie graph that summarizes the pivot data. I have no idea how to via code this. I've tried many YouTube...
  11. B

    Relationship won't work on Power Pivot

    I've attached an image with my problem, of course I did this in separate sheets and only copied it into one so it's easy to visualize. I have in the first table my sales and in the second one every article with its brand. I want to know, in each month, how many different brands were sold, but it...
  12. G

    Pivot Table and Chart using same Query/Slicers/Timeline but different groupings

    Hi All, can't seem to find a solution to my problem. I have written a query that returns data from a database that is viewed in a pivot table. I use timelines and slicers to change what I am looking at, this works fine for one table and chart. I want to create other tables and charts also linked...
  13. N

    Bad performance updating Pivottables

    I have created below model. Sales-data containes 600K rows, Dcalender 750 rows, Item info 1700 rows, Customer info 2000 rows, and remaining dimension tables app 25 rows. 2 calculated columns in DCalender, all other calculations have been created with DAX measures or M language custom columns. I...
  14. S

    VB Script for Passing a filter from a cell to multiple Pivot tables in same sheet

    I'm trying to pass a value from a cell to multiple pivots in a same sheet, it is not working. Here is my code : Private Sub WorkSheet_SelectionChange(ByVal Target As Range) With ActiveSheet.PivotTables("PivotTable11").PivotFields("[Date].[Closing Week].[Closing Week]") .ClearAllFilters...
  15. H

    Problem with Pivot tables and slicers..

    Hi, would there be a workaround for this dilemma - I have a pivot-table with a list of customers. To this table I attach a slicer showing the customers names. All work fine when selecting the client name from the slicer - but in certain cases it is easier to filter the pivot itself - and in such...
  16. R

    Index Match with duplicates

    Hi, I have a pivot table which lists football teams down column A (home team) and across row 2 (away team). The values in the pivot table are the game week that the fixtures will be played. From this, I've been able to create an Index Match which summaries the fixtures almost as required. The...
  17. P

    Pivot Table that takes data only till current date

    Hi All, I'm trying to write a macro where in the final output is a pivot table with counts of transaction, name of processor, along with Follow up date. Since the data I'm dealing with is in large number, I need only the data till 'current follow up data' and not future date. There is no...
  18. S

    How to find averages of sums in same pivot table

    Hi All, I am currently doing some Data Entry for work and I am just wondering if there is a more efficient way to do my task. Currently I am gathering total quantities of lumber used on one house, for all our houses, and finding the average lumber quantities for those lots. The trouble I...
  19. B

    Create Same Pivot but filter differnt value in each workbook

    Hi Team, I have below code where I am creating new worksheet for each director in the list and named the worksheets to the directors name. Sub test() Dim a As Variant Dim i As Long Dim ws As Worksheet a = Cells(2, 2).Resize(Cells(Rows.Count, 2).End(xlUp).Row - 1) For i = 1...
  20. A

    Power Pivot Grand Total Calculation Error

    I have a Power Pivot Table with a Grand Total calculation error. Here is the database: ABIPABAFAIAPAQ1Mailing List 1Capitalization 2Records 3Convertible Class A Voting 4Units Summary 5Capital Summary 623Mr Excel Database45Name1234566Mr Excel7Mrs Excel8Excel Jr9Total10I1I1=C4&"...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top