pivot 2016

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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