calculated

Good Day, Thank you in advance for answering this question. I can't combine two fields with an "x" value. For example, I'm combining lumber height & width so I write a calculated column =CONCATENATE(Data[Height],[Width]) and it shows 812 instead of 8x12. So then I read several websites &...

I know how to do normal calculated fields inside a pivot table and think what I want to do is not just a simple calculated field. <colgroup><col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;"> <col width="66" style="width: 50pt; mso-width-source: userset...

A1 = 2 B2 = 5 C3 = 7 C3 is the sum of A1:B2. If I were to delete the values in A1 and/or B2 what formula is needed to "keep" or retain C3 as 7. Last calculated value to remain active. Thanks

Hey All, The following formula is for displaying a time range. If a box is marked in any way it should choose the first and last time marked, in thirty minute increments from 4:30AM-12PM. However, I just added the 4:30AM spot into the sheet(new column, but cannot figure out how to have this...

I am unable to delete calculated fields OR calculated items in a pivot table. The DELETE button is simply greyed out; when selecting the calculated field or item. Workbook has no macros, is not protected in anyway.

I have two value fields in my pivot table. (1) Count of IP - showing the number of hosts out of compliance. (2) Max of Category Host Count - showing the total number of systems affected by a specific technology. I want to have a third field dividing field 1 by field 2 so I can show the...

Hi all, I have a Pivot Table with a count of actions against documents. I am wanting to include a Calculated Field that shows the % of total records. For example, let's say there are 3000 records, and 15 of them have Action X, I would like to have a calculated field return 0.5%. Is this...

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

Hey Guys, Haven't worked with VBA in Excel for years and its slightly frustrating...(considering throwing my computer out the window at this point) here is the super ridiculous simple thing i want to do: Sub Array_Formula() Sheets("Pantebreve").Range([indirect("A1000"]).Formula =...

Hi, I tried ungrouping my data and then inserting the calculated item. Which worked. However, when i try to group the data back in terms of monthly figures, it does not allow that. Could you kindly guide and advise a way to add a calculated item and still have data grouped month wise rather...

Hi All, A work colleague (who has now lef)t created a power pivot dashboard/report. Im trying to make some changes as the business has changed directions for its reporting. The dashboard imports one another excel file and then refreshes tables as you would expect. My issue is, there is a...

I've created a formula: Roundup(H3*L3,0,). I also have the Numbers option in the Format/Cell dropdown list set to 2 decimal places. The formula is producing a number calculated to two decimal places. By the same token, if I set the Numbers option in the Format/Cell dropdown to 0 decimal...

Dear Team, I have a table in the Power Pivot Data Model. I have created two Calculated Columns that are supposed to calculate the Line Item COGS for each sale. The two Formulas are identical, except for the order in which multiplication is done. For some rows in the table, the two formulas...

Hi Firstly, I need to achieve the following within PowerQuery (shockingly my employer still uses Office 2010) and not a fan of PowerPivot in 2010 (too easy to break the model!). In my PowerQuery I will be providing various rankings for based upon multiple conditional columns, what I then need...

I am in the middle of creating a financial worksheet for myself and my coworkers. I am having trouble figuring how much time we worked for free due to taxes. I have my tax rates calculated. I have my gross rates calculated. For example: I work 10 Hours, My pay is $50. So my gross rate is...

I'm trying to create a calculated field in a pivot table. The table's structure is below. The Sum of Sum of Clean Loans (I'll change the title once the data works) should come out to 82. I've also pasted the formula in the calculated field below. I've never worked with these before, and...

I have a field with the expression below: (I've made the fields generic so they are easier to understand) IIF(Field1='Example Text',[IDCode] & [IDCounty],[IDCode] & [IDNumber]) This table hopefully summarises what is currently happening: <tbody> Field1 IDCode IDCounty IDNumber Calculated...

Hello everyone, Below is a simplification of a pivvottable (OLAP!) I've created. I'm having trouble adding a column that shows the difference between the two periods I cannot use a calculated column because the source is OLAP/cube I cannot figure out how to use an MDX measure because there is...

Hi guys, Does anyone could help me? What I need is to type a color and the last N values to be calculated. N values = 1*4 = last 4 values So, if I enter 1, it needs to get the last 4 2 = 8 3 = 12 and so on... Sometimes a color has 5 cells but the fifth is always marked with an X and it is...

Have a table with a field called "Arrived Date" it will have a date value similar to December 1, 201 I am trying to create a calculated column that automatically tells me what week this is from. How do I create a calculated column that provides this. Thanks