piviot table

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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")...
  9. 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...
  10. 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
  11. 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>...
  12. 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,
  13. 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...
  14. 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...
  15. 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...
  16. F

    Pivot Table Grouping

    Hello I have a piviot table that from one data set I have grouped the date data by month, I have then created another pivot table from the data set but I do not want the date data grouped , how do i stopboth piviot tables automatily changing to the set ive grouped
  17. D

    Need to create Dynamic Title for Pivot table

    Below is my pivot table. or click below: https://docs.google.com/drawings/d/10eaRjy-nwWtIs91cU3z-hpHNFaG-QTcNVTu4n_uaK-E/edit?usp=sharing Please refer to column Center; including center-1 and center-2 and etc... Print area is set to print the report center by center separately I also would...
  18. M

    Excel data list to Word mail merge?

    I have an excel list of names, dates, and amounts owed that grows each day. I want to generate a report (using parameters) that allows me to print out summaries for each name (theoretically using mail merge?). The data looks something like this: <tbody> Name Date Due Amount owed Mr. Smith...
  19. K

    Suggestions for more 'User Friendly' Layout - excel 2007

    Hello All! I'm in the process of creating a spreadsheet that monitors the hours worked for employees under 3 different managers...there are a number of things the sheet will report such as 'total weekly hours', 'total hours worked in one shift' etc. The spreadsheet needs to cover every week...
  20. L

    Self-Populating Data Table

    Ok so I have made a self populating Data Table to show me which employee is on what shift that updates daily from our roster. This works and it's brilliant, however I want to steam line my finished product further, but haven't been able to find an easy solution. I have several employees per...

Some videos you may like

This Week's Hot Topics

Top