pivot table 2013

I am trying to insert a calculated item on my pivot table that calculates the Profit margin. I have two columns Revenue and Expense. The calculated column would look like this = (Revenue-Expense)/Revenue. However no matter where I click in the pivot table both the Calculated Field and Calculated...

My data has two columns (a start date and an end date). I need to be able to select a date and see which projects were active at that time. <tbody> Start Date End Date Funding 6/25/2012 6/24/2015 $200,000 1/1/2010 12/31/2014 $500,000 etc. </tbody> For example with the data above how...

Hi Everyone, This is my first time posting, so please excuse any accidental forum faux pas. I am trying to create a pivot table that summarizes how many parts remaining at each process sequence. Ideally, when it's complete it'll also be able to drill down on each sequence to see the number of...

Good morning all, So I'm running into Run-time error '1004': The PivotTable field name is not valid. To Create a PivotTable report, you must use data that is organized as a list with labeled columns, If you are changing the name of a PivotTable field, you must type a new name for the field...

I have a pivot table (derived from PowerPivot) that displays data filtered by a Timeline Slicer. The Pivot table is then represented in a Pie Chart which has a title. Is there any way I can link the title to the Timeline Slicer range, so it indicates the date range for which the pie chart is...

Hello, I'm trying to do something which is more of an outer-join (in database terms) rather than an Excel pivot. Essentially, I have a list of companies and products that they buy. I'd like to create a pivot table to show me the companies which aren't buying our list of products. Please note...

I have a VBA macro written (it's at work so I don't have it here) that creates a hyperlink based on a cell value. It is used to call up data related to the cell value. The displayed text is the cell value. It works fine. Next I create a pivot table that includes the column that this data resides...

I have created a pivot table, using data from two tables but rather than just expressing totals, I want to show one number as a percentage of the other, i.e. 40%, 30%, 35% in the table below. Can this be done? <tbody> Female Male Total Distinct Count Number in Cohort Distinct Count...

I have a file that contains several pivot tables originating from a data table contained within the spreadsheet. The table name is TurnData, but the data source is treated as 'GPS Turnover - P05 2015.xlsx'!TurnData. I can successfully remove the file reference from the data source, but once I...

Hello everyone I THINK pivot tables are my answer....but I don't know how to make them work in the way I want :confused: . I am using Excel 2013 on Windows 8.1 I have a database of raw information and essentially I want to be able to produce a Org Structure in a table on a new sheet: - far...

Hi All, I have the following code that severs the data connection to a couple of pivot tables on a couple of sheets. Is there a way to make the below code more compact/efficient? Sheets("DebtSummaryIII").Select ActiveSheet.PivotTables("PivotTable2").SaveData = False...

<tbody> Date Reason 1/25/2015 red 1/25/2015 blue, red 1/26/2015 green, blue 1/26/2015 blue 1/26/2015 red 1/27/2015 green, red 1/27/2015 red, green </tbody> Hello, I have a table with comma delimited data in the cells. I need to count the number of unique items in...

Hey, Perhaps you can help me with this. 1. I have some sales transactions raw data in a table, on a sheet called "MonthlySalesReport". I created a pivot table and sorted it by the salesperson's initials in the filters section of the pivot table. The rest are in the columns, rows, and values...

Need help using this Excel 2013 feature. Under the pivot table tools, using OLAP tools I can convert my regular pivot table into formulas. This allows me to insert colums, do formulas and so on..... My dificulty is that when there is new data on the source table (a new row), this new data (or...

Hi All, I've encountered an annoying thing in Excel 2013. I'm using pivot tables a lot, hence i'm creating template files, so all i need to do is to 'save as' the workbook, copy new data and refresh the pivot tables. The annoying thing is that for whatever reason the data source points to the...

Hi, Trying to add a UDF formula for calculated field in a pivot table. UDF = concat('existing field', ","). The UDF concat concatenates a range of cells with a delimiter, in this case a comma. Say the 'existing field' is a column of strings. Calculated field formulas seem very limiting in...

Hi Everybody, i was trying to use pivot filter on a protected sheet. But failed to do to that. I want to protect the sheet so that no one can alter the fields but use the filter option to view the data. Thank you in advance.

I have a pivot table where I have data broken down for the number of hours a person has worked on particular projects. The very last column of the table is the grand total and I can see how many hours total for the month each person submitted time for. This is a quick check to ensure everyone...

I am looking at historical Real Estate info. I have data in the following format: MLS#(ID) Listed Date End Date 12345 1/1/2010 1/1/2011 etc... I have about 25000 rows of the data (can be broken up if needed). I need to find a way to count the number of active listings...

I am a new user to Excel 2013 recently upgrading from 2003. I am using a Table which is linked to an external data source (SharePoint List). In the Sharepoint List there is a column which collects text data "Notes/Comment". The external data link works well and all the data from the...