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...
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...
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.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
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
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
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.