pivot calculated field

  1. A

    Pivot tbl. calculated field - sum of two "regular" fields but only if Field1 matches certain value?

    Hi all, I have a pretty simple problem - I wish to create a calculated field in my pivot table. This calculated field needs to SUM two fields, that already exist in the data source, but with a little twist. Here is an example which will make this much more clear. Source data: <tbody> Market...
  2. H

    Calculated field in PivotTables

    Hi, First time posting but been following for a while. I have a problem i simply cant figure out how to fix. In my pivot table, i have showed sales as % of grand total, for current year and previuos year, divided into categories and i want to show the difference through a calculated field...
  3. E

    Including Named Range in Calculation Field through VBA

    Hi all, Newbie to the forum here. Wondering if it is possible to include a Named Range within a Calculated Field in my Pivot Table. The Named Range is "Period". Essentially, I require a calculation which looks at the field "Actual Entered Amount" / "Period" * 12. This field would then be...
  4. Z

    % Diff for Grouped Months in a linked Pivot Table

    Hello, I have a pivot table set out as below, with the dates grouped by Month, Qtr and Year. The pivot table is linked from 2 data sources <tbody> QTR4 OCT NOV DEC FC AC %DIFF FC AC %DIFF FC AC %DIF APPLE 100 110 10% 50 100 100% 70 50 -29% ORANGE 20 40 100% 20 20 0%...
  5. K

    Calculated Field in Pivot Table

    So I have a pivot table that sums how many referral were made in a month for which month. Essentially calculating the number of future referrals. Now I need to create a calculated field in my pivot table that subtracts the referrals made in the same month. Below is what my pivot table looks...
  6. J

    Calculating difference between totals in different pivot tables, where some fields do not match

    I have a single table of data that contains a number of different numerical/text fields against a record. They also have a calculated yes/no indicator depending on whether that record meets a particular criteria. I then have a number of pivot tables on another worksheet that calculates the...
  7. P

    Difference between two columns in a pivot table

    Hi all, Hoping someone can help me with an issue I'm having with pivot tables. I have an example below. I have a pivot table with two columns that are "Show values as...% of column total". I'd like to find the difference between those two columns without having to do a calculation outside of...
  8. N

    Formula with "if" "and" between two values "sumifs" data from pivot table

    Hi Mr. Excel, I am stuck on the following formula. =IF(OR(Nmd1>="200",Nmd1<"300"),SUMIFS(A1,Nmd2,'Sheet1'!$A161),"0") Nmd1 & Nmd2 are both named ranges that link to data in a pivot. Example as follows "=+'DATA PULL DOWN FROM SYSTEM'!B4995" This formula works, but I need this to return the...
  9. O

    Pivot Table Custom Calculation

    Hello, I have a pivot table in which I want to have a sum shown as a percentage of subtotals. It is quite simple to do it, however I want to apply filters... and when I apply them the prior calculation is lost. Is there any way to maintain the percentage calculation of subtotals (including all...
  10. M

    Calculating avg(win)/avg(loss) for grouped data in pivot

    Hi there, As shown in the screenshot I am struggling to correctly calculated "Average(winning trade)/Average(losing trade) for grouped data. Could anyone please provide suggestions on what I am doing wrong? My excel sheet for this pivot is located here...
  11. R

    Calculated Field / Column / Item in Pivot Table

    Hello, I need to calucate growth from the single column data in the pivot table. I have Sales Amount data for the year 2014 and 2015 in the single column and year and month details in the different columns. Need to create growth % column from the Sales Amount column. If I had Sales Amount...
  12. A

    Subtract values from pivot tables in pivot table format

    I have two separate pivot tables with same row labels but different report filters. I would like to combine these two pivot tables together and get a the difference in values. Please see below for example, I have the sample table and would like and then I made 2 Pivot Tables based on the data...
  13. D

    Pivot Table Subtotal calculations

    Hello, I am working on creating a report using a pivot and I can't seem to get the subtotal to calculate properly. I have broken out each departments totals by its group and I used a calculated item to create the combined field ( group a + group b + group c + group d). I need to have to...
  14. J

    Removing 0 values from data and legend

    Hi All Well this is my first question in MR EXCEL, hope I can explain better I have made a graph, which is taking a data from a table (please see the file from below link). The problem is; sometime there is no data in a series value, still excel take it as a blank-legend. I tried using NA() in...
  15. J

    COUNTIF As Pivot Calculated Field

    Hi - I am trying to add a calculated field now to my pivot which will essentially output for me the # of rows in my data where the value for # slides in body of report is less than 35. I tried using a COUNTIF formula, but I keep getting an error stating TOO FEW. Not quite sure what that means...
  16. L

    Pivot table calculated fields

    I have a sheet with sales for a couple of months, and I'd like to have a chart show me the sales of months and how the price change per unit has affected its sales. So in other words a typical price/value chart. There's a caveat, though, I don't have the explicit data of when the price change...
  17. S

    On copying pivot table and changing datasource some calculated formulas disappear

    I have 10 datatables on 10 tabs in a workbook, each tab named 1 to 10. Each pulls in the same data types by column, the data in the rows being diffferent. Each datatable will pull in various number of rows of data. As such I created named ranges (data1 for tab 1 data; etc.) and use an offset...
  18. oldeirish

    Help with Pivot Table Data Calculation

    I have data in a Pivot Table that I’m showing Sales by Quarter and Total Sales (Column) and Sales Rep (row). I want to show whether or not the Sales Reps have made the quarterly quota, and whether it’s below or above the quota, and the percentage of the how far away from the budget it is...
  19. P

    How can I display the pivot table display of a calculated field as an absolute value

    I have a pivot table in Excel 2013/Office 7 that is calculating a change in our operating income from year-to-year and showing the difference as a percentage. In my Value Field Settings it is: *Show Value as a % Difference, Base Field is Fiscal Year and Base Item is Previous Year. In the...
  20. K

    Calculated Field in a pivot table using a Pivot Table Grand Total

    Need help please with a Calculated Field in a pivot table using a Pivot Table Grand Total in the formular. Example: Acme Corp purchased 3 items from ABC Co and received three invoices (A01, A02, A03) form ABC Co for those items. Below is a link to dropbox where I have the pivot table and...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top