calculated field

Hi guys, I'm working with pivot tables in excel and historical monthly returns for different mutual funds. I'm trying to calculate the historical monthly returns of each fund net of all management fees. So I have a series called 'MonthlyReturn' and one with the annual cost of each fund called...

I want to divide the Values below by a number. Here is the Calculated Field formula I created: = Metric / 350 The calculated field returns a zero value rather than dividing the monthly value by 350. What am I doing wrong? Thanks for any help. <tbody> Sum of Actual Years Quarters Period...

Hi everyone, I've been wracking my brain for the past two days trying to figure this out. I'm not very proficient with pivot tables, but I'm hoping you gurus can help. I tried explaining myself in a different forum, but I don't think I was making sense...so I've created a worksheet with fake...

Hi there, I'm having trouble calculating the values of two fields in my pivot table using Calculated Field. The value field settings is being displayed as % of row total. The Column labels (Detractor, Passive and Promoter) are taken from the field called "NPS2". I'm trying to get the pivot to...

Hi, I would like to use the ROUNDDOWN function in a calculated field on a pivot table but I am not having much luck nesting the function with the formula of the calculated field. The calculated field formula currently looks like this: = COLUMNX/COLUMNY Column X contains hh:mm:ss data...

Hello, I want to create a pivotchart in which I want to show only the % of one item from its subtotal. Using % parent I can easily calculate the %, however when I filter only that item it returns 100%. Of course, because now the subtotal is only summing its values. In the below example: I...

I'm developing a database to log all support calls that come into my desk, and I store the date and the time in separate fields when the call comes in and a new record is created using the =Now() function. I'm using a calculated field to form what will be the standardized format disposition that...

Good morning, I'm using Excel 2010 / Windows 7 Professional. I have a table that I would like to summarize with a pivot table. I'd like the pivot to have sections for the 3 different types below and then show the detail for the various descriptions and calculate a "net income". That is...

Hello, I'm trying to perform a custom calculation in a pivot table, but I'm still struggling with it. I want to do something like = Average (FieldX) * Count (FieldX) Is this possible? Regards, Pedro

Hello, I'm struggling a bit to create a calculated field in a Pivot Table. I want to create a field like this: = Count(FieldA) * Avg(FieldA) I don't know if it is just syntax mistake or if it is not possible at all. Thanks, Pedro

Hi I have been searching online and unable to find an answer I am looking for. I am trying to create a calculated field in a pivot table using the NETWORKDAYS function as part of the calculation however I am unable to create it with success. My question is: are there only certain functions...

I have been searching for a viable solution to update a calc. field inside a pivot table and can't seem to find a solution. Here is why Im looking for a way to update the calculated field using a formula or other method Currently I have to manually update the calculated field "Report Month" to...

Hello, I've tried searching for a solution, but to no avail. Below is a sales report of some Nike sneakers. Product is the item down to size level. Master is the Option Count. For example, a t-shirt, 400280 comes in 3 sizes, S, M and L. Hence why product is 400280-001 (small), 002 (medium)...

I'm trying figure out how to create a calculated field which will return the hit rate based on awarded/lost opportunities. I have created a pivot table with some dummy data looking like this: I'm trying to to create field that will return the hit rate (Awarded / Awarded + Lost) for each...

Is there a way to create a calculated field which auto increments by unique ID's in another field? For example, see CalcTime in the data set below. Starting with 1, it numbers each row until the PROP changes and starts over again. ID---- PROP---date-----CalcTime 1----- abc---1-Jan----- 1...

Hello, I am trying to create a calculated field that is based off of the same field. For example, I have a field in my pivot table named 'Answer' The Choices are: Yes, No , N/A. Currently I have it displaying the count of 'No's for each row. I would also like to create a field that shows the %...

Hello all, I am having what seems to be a trivial issue - how to add a calculated field to an Excel pivot table, a field which keeps the running total (or cumulative) based on some other field? Example: ---- Total plan: 400 days: 4 ---- Day 1. Daily plan: 100; Cost: 90; Running total...

Hi, I have no problem setting up KPI using set value. However, I have different targets every month. I can't just change the set value every time I want to view the month. Please help. Any Idea how I can approach this? I tried adding target value to my raw data and sum that column as one of...

Hi Guys, Not sure if this problem has been posted earlier or not, but here is what I wish to do. I have attached a snapshot of the problem here... Basically I want the LOSS Column to be seen as % of GRAND TOTAL of Order Column. And this has to be done using the CALCULATED FIELD function under...

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