piviot table

  1. P

    Do I need Power BI or Power Pivot?

    I am trying to use relationships or data models instead of using Vlookups, as Vlookups are slowing down the spreadsheet. 60,000 formulas for a 15,000 row spreadsheet. I am having difficulty getting the information I want. Table 1 is named GL. Table 2 is named CreditCard. The ID is the foreign...
  2. L

    Aggregate data from multiple workbooks into one

    Hi All, I'm looking to aggregate data from multiple workbooks (20+) into one represented by graphs. All workbooks have worksheets by day. We want to create daily trend graphs with data from each sheet within that workbook. Oppose to creating one master workbook that has all this data (which...
  3. S

    Pivot Table Help - Is this even possible???

    I have a large data set and I am hoping to create a pivot table off of it. My concern is that I don't think it is possible to do how I am envisioning it. I keep getting a big red "X" and denied sound in my head when I think about how to create this pivot table. My data table has multiple...
  4. C

    How to link data from multiple worksheets which uses the same cells values

    Hello Excel World: I have a problem. I want to extract data to create a list from workbook (B) into another workbook (A). NB: Using the "=" sign is hard and long to extract data. So my point is: On workbook (A), I have a list of countries names from row A2 to row A51 Next. On workbook (B)...
  5. S

    Conditional formatting for individual subcategory ?

    Is it possible to automatically apply data bars to pivot table like this? As you can see there are individual data bars for every subcategory (dates) , and they are not related to each other on category level (item) To make it more clear on what I mean, here is how it would look like if I used...
  6. S

    DAX last date Prior to a specific date

    Hi I'm trying to figure out what the last discount was on a Prior date. I have the following: tblInvPriceDisc that has a list of all the dates and discounts for all sku's tblInvSkuMaster that has a list of all sku's in the company ConfigurationTable that has the date i'm looking up. I would...
  7. D

    Pivot Table % with a difference

    Hello I have a question regarding pivot table percentages I have PivotTables similar to the below QTY. % row1. 15. 15.00% row2. 10. 10.00% row3. 75. 75.00% The percentages are set as percentages of grand total, I would like to be able to add...
  8. A

    Getting Data from Pivot Table

    Hi, I've got a series of pivot tables in my spreadsheet that show the records on a set of shelves in various different ways. I've written code so that when my workbook opens a right click command called 'edit record' appears on all pivot tables.. I'm trying to use vba to populate a userform so...
  9. D

    Pivot Table to show CC data between two monthly dates

    Hello Cannot seem to find an answer on here unless i am poor at searching. I bring my data into PQuery clean it and send it back to Excel. I then run a PVTable but like all Credit Cards they run between two dates. Mine is 19th to 18th of next month. I am trying to show in a PVTable a table...
  10. B

    Pivot table macro and text instead of numbers help

    Hi Guys, I am very new to pivot tables and I was just wondering if anyone can help. I have a pivot table set up at the moment for out of stock orders. Report Filter - Account number Example : 12008003 Row Labels - Order Number Example 818042187 Row Labels - Item Description Example Apples...
  11. J

    Pivot Graphs

    Hi, I am hoping that someone can help me figure out how to accomplish this. I am trying to make a dashboard in a way. I need to have 11 graphs as follows: graph 1 is going to be over all sales for a category Example "Women's" that will have a slicer with it so they can pick what category...
  12. S

    Need help Filtering a pivot table with a range from another pivot table. HELP!

    Hi I have 2 pivot tables. Pivot table 1 (TOPn) filters my top "BRAND - MODEL" field. I would like to use the results from that table. Let say a named range as the list can vary in length. Use those results in Pivot table 2 to filter the same field name "BRAND - MODEL". I've tried code from...
  13. U

    Filter search and post up results... VBA issue "424"

    Hi all I'm trying to create a function to filter and search through a large table on another sheet, and then post out the results which match the criteria. I've got this, but keep getting a 424 error: Sub AutoFilterBackoutput() Dim LRO As Integer With Worksheets("USD-Bonds")...
  14. A

    Pivot Table - ungroup similar items

    I would like to ungroup similar items in the pivot table that is grouped by default, for example, I have in an invoice column on a worksheet 2 x the same invoice number (12345) the pivot table row will recognize it once, how can I change that and pivot table should list that twice? Thanks In...
  15. I

    Auto refresh pivot tables vba code

    Hi. with VBA code i need that the all pivot tables in workbook updated when any make change in the sheets not with any button to click .just instantly changes happen when change the data. Many Thanks
  16. Z

    PivotTabe - Summary row - count and average

    I have a pivot table, built from a table of product adds on an ecommerce site: <tbody> Row Labels Sum of ga:metric9 Count of ga:productSku Average per ID 19-Sep 94 4 2 1139194788.1474319040 47 2 - 1139194788.1474319041 47 2 - 20-Sep 39.55 29 1191911439.1474393408 22.8 1 </tbody>...
  17. T

    Calculated item Crash

    Hi, I have a very simple "difference" calculated item in my pivot table. The problem is it freezes, every single time I change any field in the pivot. The background data isn't very large and the formula very simple. Any idea's why this might be happening? Any ideas how to fix it? Thanks,
  18. R

    Drill down levels on pivot chart

    Hello, I am having trouble setting up a pivotchart and was hopin to get some input. My data consists of the following: 1 column of US Regions (South, East, etc) 1 column of US State 1 column of State's population. The chart is just a standard bar graph. I want the chart to display the 4 US...
  19. T

    Comparing historical data

    Dears I need your help and support on this please I am trying to fnd a formula or VBA code or using pivot table or even excel 2016 pivot table to do the following: To compare grades for each ID and show the result in the result column, if grade for ID 1 in 04/01/2016 greater than grade for ID...
  20. A

    VBA to move pivot table field name to rows

    Hi All, I have a bit of code that will move a field name in a pivot table to Rows. When I record the macro this field name is hard coded ( see example below). What I'd like to do is have the hard code value replaced with a value in a cell, so I can have data validation in this cell and change...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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