calculated field

I am looking to create a calculated field in my pivot table using the value generated from the 'percent of parent row'. I'd like to multiply it by another column but am finding that this might not be possible. Is there a way to do this? Or if not, is there an alternative? The pivot table has 4...

Is it possible to create custom error bars in a pivot chart that are based on a calculated field? I would like to create a bar chart representing PROPORTIONS with error bars that represent the CONFIDENCE INTERVALS. My data contains N items that either can be "failed" (0) or "passed" (1)...

I have an Excel 2010 workbook that includes the detail for a portion of the population of data. The portion was selected based on certain criteria. Research was completed to test compliance. The results are displayed in a pivot table. I need to calculate error rate based on a second report that...

Hello, I have a report with a date slicer that returns, by sales manager, by sales rep, by account, the current period revenue and prior year revenue for the sliced date range. I need to add a column that counts the number of accounts with revenue in the current period. The data source is such...

Hi Any help would be greatly appreciated as I'm a novice at pivot tables. I have created a pivot table to summarise a large data set . I have calculated the average size within the pivot table and a column that shows the max size allowed within spec. What I would like to do is to have a...

hi all, This is the SQL data I imported into power pivot: <tbody> ProfitCenter_Name Account_Group Project_Group Fiscal_Year Q_FY Edition Edition_Type Revenue A AA AAA 2018 Q4/18 Actual Internal 5 A BB BBB 2019 Q1/19 Actual Internal 9 B CC CCC 2018 Q3/19 Other External 10 A AA AAA...

Hey guys first post, good morning (well here anyway) to you all. I have looked for a solution to this and am hitting a bit of a blank, I am sure it must be answered somewhere Excel 2016. I want to add distinct count to a pivot table. in its simplest form, its sales rep, order counts, and...

I'm trying to use a Pivot Table Calculated field formula of IF(Column 50>20,"YES","NO"). It is only returning #VALUE . The formula works when I change the return values to numbers. Is it not possible to return text from a pivot table calculated field?

I have a table which summaries a list of purchases made by customers. In this table it has 3 columns, the customer ID, their max budget and the purchase amount. I wish to make a pivot table which shows compiles the sum of purchases for each customer and the % of their budget used. I had no...

Hi everyone, Apologies if my question has been posted or solved before, however I could not find so here I go. I have a series of HR headcount data, which contains various columns of 1's and 0's. I am trying to figure out turnover or attrition, but I would like to calculate this within a...

This is Pivot table. Field1 is counted as Bottle price / Volume. But Subtotal for Field 1 is wrong. 21,2654321 is wrong answer, watching data, we understand that price of Bottle per Lt is 65. For some reason, Field 1 is taking all volume. Perfect Formula would look like this...

I have tried a mix of calculated fields, and variations on showing values as % of rows/columns etc and cannot come up with a working solution. I would like to have a column that takes the "Orders with Cost increase" and shows it as a % of the grand total of the "POID count" For the first...

I have Make Table query that evaluates a field, replaces an undesired character ("*") with another ("_"). The replace function within the calculated field works correctly, however errors appear in the results. This creates problems down the line. Is it possible to somehow exclude the errors...

Greetings, I'm trying to expand upon my use of Pivot Tables, to generate a calculated field to replace a table that currently exists beside two pivot tables and calculates data off of them. Because this table doesn't rearrange itself alongside the two pivot table, which include row level...

Hi, I need help to create a measure for Weighted % of Active employees by agency. My logic is : Weighted % of Active Employees = (Active Per Agency/Total Actives All Agency) * (Total Per Agency/Total All Agencies) Following is a sample of my pivot : I choose : I get: All I...

Hi, I have the below data and i want to calculate score. As of now, i calculate this after the pivot area. Can i calculate it inside the pivot using calculated field / item ? <tbody> Transaction Id Region P1 P2 P3 P4 Good Score A989 KAR 1 FALSE 75% A789 KAR 1 FALSE 75% A900 KAR 1...

Running Excel 365 Pro Plus. Have a Table with approximately 100,000 rows. I tried creating a Pivot Table from this table from my Data Model, but Calculated Field is greyed out. Research indicated that using a Data Model somehow restricts Calculated Fields in a Pivot Table that is part of a Data...

I think this is an insanely easy problem to solve, but I am not positive how to go about it correctly. Here is the scenario. I pull the same report every day. This report compares the previous day's report, stored in Table1, and compares it to the current day's report Table2. This report has an...

Morning - hoping this is a quick and easy fix! I have an option button on the same sheet as a pivot table. The pivot table has two similar calculated fields currently Within SLA % = 'Within SLA' / Projects Outside SLA % = 'Outside SLA' / Projects What I want is to toggle both calculated...

Hi all, After years of stalking this forum for solutions, I've finally come across a problem that I couldn't find the answer to. Thank you very much in advance for your help. I am trying to add a rolling average to my pivot table. In the example below, 'chronic load' is a rolling four week...