calculated item

  1. P

    Drilling down in a calculated item in a pivot table

    Is it possible to drill down on calculated items in a pivot table? On non-calculated items, I can drill down just fine--by double-clicking the item, it creates a new sheet with full details. However, when I double click on a calculated item, Excel just displays the formula that comprises that...
  2. V

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

    Displaying % in power BI

    My data is structured as below (snippet of data) <tbody> ID Location Status AP001 Location5 Booked AP002 Location3 Pending AP003 Location2 Lost AP004 Location7 Lost AP005 Location4 Booked AP006 Location2 Lost AP007 Location6 Lost AP008 Location1 Booked AP009 Location7 Lost...
  4. G

    Calculated Field / Item

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

    Display of Calculated Items in Excel

    I created a PivotTable to present the budget for the year using 2 Categories (A, B) and also create a Calculated Item (= Spending / Budget) showing the percentage of the budget used. In the first Pivot Table of the image the percentage calculation does all right, but when another subcategory is...
  6. L

    Calculated Item - How to associate it with only one pivot table

    Hello I was wondering if there was a way to allocate a calculated item to only one pivot table on my spreadsheet. I.e all of the pivot tables use the same source data, but when I add a calculated item to one pivot, it shows as an option for all my pivots. I'm not sure how the logic works, but...
  7. R

    Help with value fields in Pivot Table (calculated/ item field?)

    Hi, I need to show the values in the pivot table below a sa % of the total unfiltered values. The table below is filtered by Bank Code = Bank X. But I need the values to show as a % of the total Unfiltered number for each cell, by industry row on the left. Tried changing The Values Field...
  8. R

    Calculated Item - CALCULATE YoY Variance for all measures

    Hi everyone please help, I would consider myself very advanced in excel, however started working with larger sets of data and started using power pivot. and it feels like I am starting all over again. I am watching videos on CALCULATE but am still trying to wrap my mind around it. This is...
  9. D

    Help with conditional statement in Pivot calculated item

    Hi There. I need some help in creating a calculated item in a Pivot table. I have a field that indicate product thicknesses in millimeters. I want to create another field that will categorize thickness range as light, medium or heavy so that in the end I can determine the tonnages I have of...
  10. F

    Calculated Field/ Item query - calculating differences

    Hi I’m currently trying to work out the difference of two valuations (internal and external) in a pivot I have created. Currently my Pivot is arranged as follows, source data (internal or external) as column labels, Product as row labels with a further break down by office region of...
  11. D

    Calculated Item; wrong sub and grand total with percentages

    Hi, As the head line hints at, I'm having some issues with the Calculated Item function in Excels pivot. I'm creating a report with the current and previous year, where I calculate the years sum as a percentage of yesteryears. It works row by row, but for each total it adds all the row totals...
  12. S

    Subtotals for pivot table with calcuations

    I believe this is not possible (as i am getting an error saying so) but does anyone have a workaround for getting monthly subtotals on a pivot table where there are calculated items? i've tried two ways: - highlighted date in the pivot and clicking field settings and then custom and then sum. i...
  13. T

    Creating a products gap table with a Pivot Table and calculated fields or itms

    Hi, Please see the link below. I have a table that I need to make a balance of inventory. I would like to know how to do it with a pivot table ( I did it with sumifs ) http://sdrv.ms/162zrhs Thank you, Tamir
  14. B

    Pivot table calculated item as new data in the source data tab?

    Hi, I have a pivot table with about 12 columns and 50,000 rows in a tab. I want to created a weighted sum across a few different items for a given institution in a given year (e.g. Item A*2 + item B + Item C in 2000 for institution A and again for institution A in 2001, and so on for...
  15. K

    07 Pivot Table Calc'd Item (%) Sums in G/T line

    Is there any way to change the formula for a calculated item in the grand total row? Excel 2007 & Windows XP This is a subset of the results: Overtime Total Time % Mfg Cell 1 715 6,201 12% Mfg Cell 2 2,983 14,656 20% Mfg Cell 3 710 7,567 9% Mfg Cell 4...
  16. G

    Totals in Pivot Table for calculated item does not agree to sum of the detail lines

    Dear All, I ran into a bug concerning automatic totals on calculated items in Pivot Tables. I am using Excel 2003. I have two columns of summed values in a pivot table. I created a calculated item that takes the lower value between two columns and multiplies it with a rate. For example, the...
  17. J

    Calculated Items in Pivot Tables - only sum fields if present in data

    Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I’ve been thinking about this for ages and just can’t think of any way around this – I’m sure someone out there must have some genius way of doing this. <o:p> </o:p> I’m coding some VBA to make some...
  18. C

    Pivot table calculation using a calculated item and field

    I would like to create a calculation in a pivot table using a calculated item and a value from one of the time periods displayed. ie. database contains transactions listing price and quantity. Pivot table contains calculated field = average price per period. calculated item = difference of...

Watch MrExcel Video

This Week's Hot Topics

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.
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.
Go back
Top