calculated field

Hello, can I ask for help your help. I find it hard to solve the percentage of Lost Calls by date and language. Please see sample below: . below is a sample data, for reference. Wait Time Name Status Call Duration Language Class Date Offered 12/2/2018 00:23:20 00:00:41 LOST 00:00:00...

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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