calculated field

1. Error in simple operation in new calculated field

I am new in Access (and not currently planning to go deep). I want to do simple operation in new calculated field: (1) combine two text fields with "__" delimiter, and (2) multiply/divide numberic field with a value. Then, I will save the Access and load it to Excel as a Pivot. I saw this video...
2. Pivot Table( calculated field showing diffrence between two columns values show as % of the column)

Hello, I have a simple pivot table with name of a product and sum of sales in year 2021 and 2022 shown as procent of the total column). Im trying to add a calculated field that would show the diffrence between the two years. For istance in 2021 sales of apples was 15 and grand total of sales of...
3. Pivot table dates and data

Excel Office 365 I have a pivot table with dates across the top in row 1, names in column A, numbers in the cells below each date for each person. I am looking for a way to provide a sum of the numbers for the dates that are on Friday, Saturday, Sunday while still keeping the other dates and...
4. Get Maximum of Value Field in Pivot Table

Hi All, I am trying to do the following, please let me know if this is possible: I have a "Value Field" called Count of Value_Proficiency which simply counts the occurrence of each Row Label I would like to create a new "Measure" having Max of Count of Value_Proficiency repeated for all Row...
5. Pivot table Calculated field for Projected Year-End based on most recent month value

Hello. I have a pivot table showing monthly revenue for fiscal year beginning Jul ending the following Jun. How would you add a calculated field to show projected year-end total based on Jul-Sep total, plus the projected revenue from Oct to Jun, based on the Sep value, assuming the Sep value...
6. Use Ranked Values in Pivot Table Calculated Field

Hi, I have this pivot table with ranked values of 1Yr and 5 Yr returns of various funds. I am trying to create a calculated field column with 50%*Rank1Y + 50% Rank 5Y. However, the calculated field doesn't let you choose the ranked values as the base for the formula. I was wondering if there is...
7. Pivot Table Calculated Field Suggestion

Hello, I'm attempting to make a simple calculated field that will change based off in and out values of stock materials. I understand how to use the basic pivot table calculated field, but I can't figure out how to make it possible. Ideally, I want the field to be equal to as mentioned in image.
8. Excel Pivot Chart add Horizontal and Vertical Lines

So I have tried a couple of things and ran into a couple of problems. First of all my desired situation: I have a Pivot Chart based on data which contains Dates, Values and Locations. (A2A, A4A etc. are locations). I want to have a legend based on the different locations so I can see which...
9. Calculated measure in Pivot Table

Hi! I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc. This is an example of the data table which I use: And this is the pivot table which I...
10. Pivot Table - Values as a % of Maximum of Parent Grouping

I know that title sounds a bit confusing. I have various fees grouped by departments. Customers may only belong to one department, but they may pay one or more fees in their department. I have revenue by fee type, as well as the count of customers that paid each fee type. I would like to...
11. Pivot Table: Calculating Average % Across Years

Hello, I have a Pivot Table with Years as the top-level column, then two fields underneath, Cash and Operations. The values in each field are currently calculated as % of Parent Column Total, so Cash and Operations are shown as percentages of each year's total. I would like to also create a...
12. How to use a Pivot Table to sum the last 12 columns

Hi Everyone, hope you can help....as usual. I have a pivot table based on an enormous database which essentially summarises each month points by individual. I need to keep all historical columns in the pivot (this is going back to 2012) but would like the pivot to calculate automatically the...
13. Pivot Table Calculated Field subtotals

I am working on a pivot table based on data that has a region, a sub-region, dates, and then the available work potential in each sub-region by date. I need to do two things, 1. I need to create a calculated field based on the available work potential 2. I need to change the subtotals to...
14. Pivot Table Calculated Field Error

I have a pivot table and one of the values I changed the value field setting to "AVERAGE" but the calculated field is calculating based off of sum. How can I get the calculated field to calculate off of the average? The Surplus Shortage field is my calculated field where I am taking Inventory...
15. Question calculated field pivot table

Hello, I have a question. I would like to calculated ratio's from a database with balancesheets in a pivot-table. The data is as follows: <tbody> Company Balance Sheet no Description Value Year Apple 3 Cash 25 2018 Apple 4 Inventories 35 2018 Apple 5 Short Term debt 75 2018 Facebook 3...
16. Calculated Field in Pivot Tables

Hello, I have the below fields in my spreadsheet that I would like to place in a pivot table. I want to calculate the sales turn for the aggregated with the formula (BOH \$/Sales \$)*# of weeks in the month. I have tried using an if statement in the calculated field =if(weeks in month>4, (BOH...
17. Pivot Table Difference From (or maybe something else)

I'm trying to calculate the difference in TY vs LY numbers in a pivot table. My set up is: Rows: Client Name Sale Date (grouping by month) Columns: Years (for the TY vs LY comparison) Sum Values: Sum of Sales For example <tbody> 2018 2019 Client 1 May 100 1000 </tbody> I want to...
18. Calculated Fields Greyed out in Pivot Table with Data Model

I watched the YouTube Video - Budget vs. Actual - Podcast 2016 where a data model is used to compare an actuals table to a pivot table, by using intermediary "Joiner tables." It's a great solution! I am trying to expand the idea by introducing a calculated column for the difference between...
19. Pivot table and divide one calculated column by another column

<style></style>I have one column that counts all the document names on a certain date and sums the values on that day. I am wanting to add a column that will divide the Duration by the sum of the Doc Names on that day. I cannot get the calculated field to do the correct calculation. I am...
20. Using % of Parent Row Value in a 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back