calculated fields

  1. adrienne0914

    Average Calculated Field on Pivot Table

    I am trying to insert a calculated into field my pivot table so that it gives me the average for the last 3 months in the last column. When I use the formula =AVERAGE(Last 3 months), it inserts a formula between each column, rather than giving me an average to the right. I'm sure there is a...
  2. D

    Pivot table- inserting row that is function of items

    Hi- I have created a pivot table and want a % calculation on a row. I can not use calculated fields as it is an item in a field and I can not used calculated items as the items are in two different fields. For anyone financially minded it is a gross profit %. I have my pivot displaying total...
  3. H

    Add Calculated Field/Formula to Pivot Table referenced as a Data Model

    Afternoon, I have a pivot table references multiple tables (when creating the pivot table, i chose "add this data to the Data Model"). I have the relationships I need created, but when I go to select calculations to enter a formula and it's grayed out. I have sales data based of months, and...
  4. D

    Pivot-Table - Difference from total runing-in

    Hello everyone, I am building a cash management file and I managed to get it well untill I want to finalize my pivot-table report. The thing I am trying to obtain is exactly describe here : https://www.youtube.com/watch?v=q5M20UwxY1Q but for a confusing reason I don't obtain the same result...
  5. G

    Pivot Table Calculated Item Includes all accounts from Profit and Loss Statement

    GM Excel Crew, I am having trouble and I need some expert advice. I am recreating a PnL statement using a Pivot table. It gives me lots of flexibility for my needs for analysis. However, there is one problem that is driving me nuts. In this PnL there are lets say 50 accounts. Of course its...
  6. D

    General Question when creating a calculated field uisng a percentage in a pivot table

    I am a bit new to creating a calculated field in a PV Table so I am not sure of all the restrictions. I have noticed that when creating a calculated field the default is sum of "your filed" and selecting different options does not change the value. What I need to display or calculate is one...
  7. N

    [Calculated Fields] how to Get Count Product more last month

    i want to used [Calculated Fields] on Pivot table to show customer buy number of product compare last month Ex Month 1 Customer 1 Buy 4 Product A B C D Customer 2 Buy 3 Product A B C Customer 3 Buy 3 Product A B D Month 2 Customer 1 Buy 4 Product A B C E Customer 2 Buy 3 Product A B D...
  8. D

    Pivot Tables Find difference between 2 columns where fields are not in data set

    Hi I have a data set where the data has a column called Fin Yr and the column is populated as FY15 or FY16 When I show these in a pivot table column view (across) I want to create a new column to show me the difference between the Fin Years Can someone please advise how this is done as a...
  9. G

    Calculated Field not Working in Pivot Table

    Hi, I'm working with a pivot table in 2013 counting dates in various fields. I added several calculated fields to determine conversion rates from one category to the next and all works well. I am attempting to add further calculations, but for some reason the same fields I have been using are...
  10. G

    Calculated Pivot Field Woes...

    Strange issue I'm hoping someone can help me out on: I have a tall data set that has an amount tied to a person and a date, say like such (as a simplified version - the actual data has several thousands of lines for individual people stretching back 90 days): <style type="text/css">...
  11. J

    Pivottable, Calculated Field,

    I'm having problems with calculated fields in Excel 2010 when adding columns to the data source. Adding columns results in calculated fields becoming corrupt! Datasource DataRep DataSales DataCOS Tom £300.00 £150.00 Deek £200.00 £100.00 Harry £100.00 £50.00...
  12. A

    Calculated Field - variance to column total

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

    Slicers

    Right now I have a slicer named "Clients" with options for Client 1 to 8. This is controlling a PowerPivot table. I was wondering if it would be possible to eliminate an option from the slicer. Essentially what I want is that Client 8 always remains chosen. I would only like the user to have the...
  14. M

    Pivot Table Data Crunching: Calculated fields operate on sum totals

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

    I think I've designed myself into a corner

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

    Pivot Table Calculated value based on another item

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

    Pivot Table: Calculated Fields % of grand total in an equation

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

    Writing formulas using the calculated field of a pivot table

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

    Excel Pivot Table Calculated Fields

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

    Pivot Table - Calculated Field

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

Some videos you may like

This Week's Hot Topics

Top