calculated field

I've created a function that will provide me with the end date of the previous month: [[Date]-Day(Date)] which would return 1/31/2016 in this case. The problem I'm having is that when I enter that function to calculate against other date fields it comes up as a text and I get #error in the...

Hi, I have a pivot table with the following field settings: Rows: Account # Columns: Month (and Values) Values: Budget, Estimated Total Cost, Budget (Show Value As: Difference from prior Month), Estimated Total Cost (Show Value As: Difference from prior Month) I have two months of data...

Hi, I built a pivot table in Excel 2010 on basic data to count # of employees by state. I then used the "show values as" feature to show the count as % of the grand total. The next step is to apply these percentages to total revenue to allocate 2015 revenue by state. The question is can I...

I'm looking to set up a calculated field in a pivot table that shows the variance to the column total; similar to the show values as % of Column Total option in value field settings, however it has to be a calculated field and is just the straight variance. I understand that you cannot...

Hi! I have the following table (copy paste to Excel to get correct formatting): I want to create a calculated field (pivot table) which counts the unique days in this table. Anyone knows how to do it? Best regards Sober

Dear Experts, I have a pivot table which data source is audit trails. In the first column of the pivot table will hv the series of dates, second col is old value and the third col is new value. I wish to track period when the old value change to new value, but just for specific items, which...

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

Hi, I am doing pivot tables for a report. I have a field called Scores with values 1 to 5. I wanted to compute the satisfaction score for a person and it should be computed as SatScore=AVERAGE(Scores*0.2) So what I did is I added a calculated field called SatScore with formula =Scores*0.2 Then...

I have a pivottable set up to provide our accountant with a WIP (work in process) printout with the fields he needs. He loves the report except for one thing... All of the columns are dollar values, except for one, which is the %Profit field (Estimated Profit/Price). When I create the subtotals...

Good Afternoon, I asked this question about a week ago and never got any responses, so I thought I'd ask it one last time. Any help is greatly appreciated, as this one is driving me nuts. In short, I have a multi column pivot table calculating student throughput for classes we teach...

I am looking to create a calculated field in Excel 2013 that will measure the growth of sales dollars when comparing two different years. The problem I am having is that the raw data in which the pivot table is built off of does has all of the sales in one column. The report list the customer...

Hi - I am in desperate need of some pivot table help! I have a pivot table as shown below. The column titled "Value 1" is a calculated field that I added to my pivot table. The Column Called "Tier Weight" is the average of static values that are in my raw data sheet based on whether or not...

I am new to this forum and tried searching but eventually gave up - so I do apologize if this has been asked before. :( I have survey data in MS Excel. The majority of the questions were scaled from 1-4 and then there is a 0 for no response and 5 for 'I do not know'. I am trying to total the...

How can I create a calculated field in a pivot table that will count distinct values of Field1, given that Field2 meets a particular condition? My limitations: Needs to be in a pivot table Needs to be a calculated field The calculated field needs to be a unique count "formula", not simply a...

<colgroup><col><col><col span="2"></colgroup><tbody> I have table that has the same account names but for different years (sample below). I want to create a pivot item field that calculates the difference between the years for the same account name Account Name Year Amount Account 1...

I have created a metric that measure how well an individual sales person is doing as a calculated field in a PowerPivot. I would now like to use this same metric to see how their team is doing on average (if Joe gets a 1 and Jim gets a 3, then the team would get a 2). I would like to be able to...

Hello, I am not sure if this is possible but does any one know how I can add a straight line showing the average in a Pivot Table Chart. I am not able to add the average to the source data because I want to use slicers for my charts and pivot tables. Is there a way I can do this with the...

Good Morning, I've built a query in Access and am have a data type mismatch in an IIF statement. I know where the problem is but I don't know how to fix. Last night, two of us worked on for 4 hours. Ugh! When I use each part of the IIF statement separately, they work. I cannot put them...

Dear all, I am working on Pivot table and in the need of using the calculated field. I tried to find a solution in old threads but was not able to find any. Data structure: Different Products showing monthly figures for Year 2013, 2014 & 2015 separately in each column (means I have 26 column...

In one of our tables we have a measure for Zip Code in the current format "00000-0000". I wanted to create a calculated measure grabbing only the left 5 characters so we can plot them easier on a PowerView Map. I tried creating a calculated field using "=LEFT(Ship-to Customer'[Zip],5)" and i...