pivot 2016

  1. T

    Updating Pivot table using count and sum option from multiple sheets

    Hi Team, I have 15 members in my team and they are updating their volume details for each sheet (I created one sheet per member) I have to create a summary with the help of pivot by using all the sheets(sheets will have same titles). Person1 Sheet will be Name Book ID Book Title Pages Count...
  2. U

    Count of date values which are in different columns but are of same week in pivot table

    Hi All, I have a data table where we have Roles (varies) that people have been contacted for. Columns B:G contains the dates of the activity performed (e.g. when were they sourced, when they shared their interest so on and so forth). I need a dynamic weekly report which gives us count of all...
  3. U

    VBA / SumIF formula / Pivot Filters

    Hello Gurus, Hope you had a nice weekend. I was trying to find a way on how to show the "Count of Indicator" but can't figured it out on Pivot. I was thinking that if it won't work on Pivot maybe IF formula or VBA would be helpful . Raw Account Country Data Score Indicator (value after...
  4. U

    SUMIF with VLOOKUP

    Hi Gurus, Any thoughts on what would be the right sumif lookup formula for below scenario? Sheet 1 - I have a long list of Data. Simple example below: Name Change Sam 250 Mike 300 Sam -500 Mike -150 Sam -50 Mike -25 Sheet 2 - I'm having a hard time doing it in pivot so just...
  5. M

    Pivot Table driving me Crazy

    I have 2 Table as in picture attached. Relationship with employee ID and Employee ID in both table When I put employee Name in Rows Safety Courses in column And want to have Expiry Date of that course in Value section. But its is showing count of that course in Value instead of showing of...
  6. A

    having problems with pivot charts

    Hello to eveyone I want to get a pivot chart from a table that the horizontal axis has subcategory and I really dont have an idea how can I make that how ever I can not specify categories to special axis ABCD1basement poylgonstarget ratiodisplacement(cm)Initial...
  7. S

    How can you get raw data from Pivot Chart?

    Hey; When pressing on a pivot table it will take you to the raw data. Example: Pressing on number 5 for the sum of "misplaced products", it will give you the list of the misplaced products. But when a pivot chart is made out the pivot table if you are to press the pivot chart nothing occurs...
  8. B

    ??? -- Filtering Slicer Output with another Slicer, based off of the original dataset that was filtered... ... lol

    I realize that sounds absolutely ridiculous, but the concept is very much what I need. This is based off of System Condition Codes (SCC) for Work Orders in SAP. I have two columns of data - FROM (starting Code) and TO (finish code). Each digit (alpha/numeric) has a preset limitation to what...
  9. P

    Emailing from (?) Pivot data

    I'd appreciate some guidance, please. I'm running a dinner where each member can invite guests. I'd like to use Excel as the data source to send an email to each member's email address, with the body containing details of each guest (name, diet, confirmation etc). I've created a pivot table...
  10. K

    Distinct Count Function for Mac!

    Hi everyone, I was using the distinct count function in pivot tables so it doesn't count duplicates. To have it available, the flag "add this data to data model" must be marked when inserting the pivot table from the data source. This has always been very helpful to me. I am using Mac now, and...
  11. F

    Transform table with Pivot Table, DAX formula

    Hello to all, I'm new with Pivot Tables, DAX formulas and I want to know if it is possible to get the output desired with PT, Power Pivot, DAX etc. I'm using Excel 2016. This is my input Table: <tbody> DESCRIPTION VALUE STAGE 1 ID 0 NAME JFMSC TYPE MLRR DFRUL P1 ADDR 1001 RRUL...
  12. E

    Calculated subtotals in Pivot table

    I want to add calculated subtotals into a pivot table Like in a finicial report you want to se Margins after different categories I have the scenario in the tabels below. A table with balance per account, I have created an "Income statement report" in a pivot now I would like to add the 2...
  13. Y

    I'm stupid - Pivot source data with multiple columns, want columns in rows

    Excel 2016. I have source data for a pivot table across multiple columns. The first column is a date, the subsequent columns are teams, and the values are a count of faxes a team processed, for each day. I'm trying to create a pivot table in which the dates appear across the top, summarized...
  14. I

    Excel 2016 VBA - Compare 2 PivotTables fields for matching values

    Hi please can someone help, Excel 2016 VBA PivotTable objects. I rarely develop in Excel VBA (as I'm a SQL Dev). Overall Goal: Compare a single column [P_ID] value list from PivotTable2 against PivotTable1 filter field, if they exist or not to enable filtering on those valid values in...
  15. M

    Transform multi-level table format, maybe with pivot table?

    I have an Excel 2016 file with a large set of panel data in the following actual form: <tbody> VAR ISO VALUE 1990 1991 1992 IMPORTS ARG 1,287 NA NA IMPORTS AUS 9,178 447 10,792 IMPORTS AUT NA NA 1,325 GDP ARG 153 206...
  16. G

    Calculated Field / Item

    Hi, I have the below data and i want to calculate score. As of now, i calculate this after the pivot area. Can i calculate it inside the pivot using calculated field / item ? <tbody> Transaction Id Region P1 P2 P3 P4 Good Score A989 KAR 1 FALSE 75% A789 KAR 1 FALSE 75% A900 KAR 1...
  17. D

    UK Tax Period April 2017 to March 2017 Sort Group Pivot table

    Hi Guys Is their way to manipulate the data i have to show the current tax year April 2017 to March 2017 in my pivot table which has the last 5 years worth of data. I have tried filters but does not work Dale
  18. E

    Turning data Horizontal to logical table based

    hello, I have data like below. Family_Name | People In the Family ABC | 1a| 2a|3a|4a|5a CDE | 1b|2b| 3b| FGH | 1c| IJK |1d| 2d| 3d|4d| Like above I have like 15columns*5000 rows of data but I want to see it like below ABC 1a 2a 3a 4a...
  19. D

    Reference Cell in “GetPivotData” Function

    My function is working correctly when I manually enter the "CustomerAccoutNumber": =GETPIVOTDATA("[Measures].[Sum of SalePrice]",[2017Sales.xlsx]GMBlitzOct!$A$6,"[2017Sales].[CustomerAccountNumber]"," [2017Sales].[CustomerAccountNumber].&[Z4049200]") But I would like to replace the "Z4049200"...
  20. E

    Pivot table?

    Hi all, I'm new to Pivot Tables ... and not sure if this is what I should be trying to use. To keep it simple, I have a List with two columns. 1. CAT 2. ITEM CAT has Hardware, Timber, Paint, Glazing etc... ITEM has many items using those Categories. How can I Pivot the list around so my CAT...

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
Back
Top