calculated fields

Excel 2013 Pivot Table Data Crunching is a great book. I suggest that you have a look at the information about calculated fields though. There seems to be some misunderstand regarding how calculated fields work. Calculated Fields do not calculate on a row-by-row basis as stated on page 244...

Greetings, I'm an old database guy and I think it's caused me to design my Excel app in a way that won't work very well. I am trying to design a spreadsheet to track paint usage and emissions for environmental reporting. Anyone dealing with a Title V permit will know exactly what I'm talking...

Hello I need to provide a '% of' type of calculation but based on another item. I guess it's best explained with an example. Here's an excerpt from my Pivot Table (%Comm column was added to the example): <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco...

Hi, hope you are good. I have a pivot table like the example and the the third column is in show value as % of grand total. I want to create a new column that multiply the % Total Hours and the the Rate. <tbody> Name Total Hours % Total Hours Rate a 05:00 29.41% 69 b 02:30 14.71% 100 c...

All, I got an easy one for you Excel geniuses.. It concerns the calculated fields in a pivot table (PT). I want to add a field in a PT that is calculated using standard deviation and average of existing fields in the datasource. But how I declare standard deviation and average in the "Formula"...

Hello, I've looked for this before, but it's come up again at my job and now I need to find a definitive answer (hopefully in the affirmative). I have data that is linked to a pivot table and on the side of the pivot table are calculated fields (we call them "bolt-on fields"). We want to try...

I need to add the following formula in a calculated field into a pivot to provide me with some rate and mix calculations. =(sales x (Margin% - Total Margin%))-(Sales / Total sales) and so on... Total above is the grand total for the column. All the above items are on my pivot via a local...

I am trying to figure out how the person who created a pivot table in a workbook (and is unavailable to ask directly) created what appears to be a calculated column called "PO Balance". The database which feeds the pivot table contains a bunch of records representing purchase order...

Hello I´m having problems counting properly with a calculated field. (Excel 2013 64b on win 7 64b) The current calculated fields are: [Max CLOSE 1 Week] =IF([Sum of...

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

I am trying to use VLOOKUP to search a table whose location moves around depending on the data that are loaded. I want to insert computed row/column indices in the VLOOKUP formula but cannot figure out the ' and " syntax. I can store the values in hidden cells on the sheet that I can access. I...

My source table in my Excel workbook is populated from a data connection which executes a stored procedure in SQL Server, and is refreshed every time the value in one of the cells that are the parameters for the data connection/stored procedure changes (columns delineated by semicolon): trans...

Goal: To create a visualization that ranks my cities based on the filters I click on the other graphs in my Dashboard; displayed as a percentage. Background: I have 50 cities. Each city has supplies (ex: notebooks, pencils, pens). However, some of the supplies are broken. I have a pie chart...

Hello, I have a Pivot Table that I would like help with. I have two Columns Currently Current Week and Previous Week. The Values are displayed as a count for the Status Field. I would like to know if it is possibel to add a calculated formula that will take the count difference between Current...

I have been using excel pivot tables for some time and have used the group selection to roll dates into months, quarters, etc. Also, I have used the calculated fields capability to add new/useful columns. Recently, I started using the new data model capability in excel 2013 to work with...

For the Power Pivots reports that we build I frequently have to make dozens of calculated fields. Think of Invoiced in the previous year, YoY%, WoW%, Ytd etc, and this for up to 60 measures. That's why I was wondering what in your experience is the quickest way to make a lot of calculated fields...

I'm very new to Powerpivots and have never really used calculated fields in pivot tables before. I've just started in a new job and they use pivot tables alot. We've got a new reporting tool which uses PowerPivots and it's very impressive and much quicker than our old reporting tool. However...

hello all, learning Access and I'm stuck. Is there a way to create a calculated field to find the last value in a row of a record? What I have is an employee DB so the unique is the employee. along with other data, i have management hierarchy to the top as fields manager level 1, manager level...

I am trying to create a pivot table with Base data like this below. I am trying to now add a ratio of PM to demand and filter for assets where this ratio is high or low. I can get the table to display each percentage but every filter I try doesn't seem to work. Can this be down outside of adding...

Hi, I'm trying to do something I think of as very simple, but I cannot seem to figure it out. I'm doing a comparison of values (so the same field) with different attributes over time. I'm simply trying to calculate this delta field using fields so that I can dynamically generate the...