pivot table calculations

I am looking to add a measure for my pivot table that will do a simple pass fail rate calculation. The calculation is =pass/sum(pass, fail) how do I translate that into pivot table language? There are 4 basic criteria I am working with. Inspection ID, Date/time, Eval Area, and Rate Status. The...

I think Excel only allows running total percentage calculation using the subtotal as a denominator. Can I set the grand column total as 100% instead? Thank you!

I have a pivot table with two columns that are averages. When I insert a calculated field to subtract one from the other it looks like I am getting the sum of the differences something like Item target weight avg actual weight diff abc 10.00 10.50...

I am trying to create a "ITEM" formula for my pivot table. Does anyone know if it is possible to reference a cell that is not included within the pivot table? Here is my formula that I am trying to create but I am having problems. Excel won't let me use this equation. Does anyone have any...

I have a Pivot Table which is filtered, so the number of rows in the table varies as the filter conditions change. I now want to be able to take data from the filtered pivot table and do some further calculations, such as calculate the Maximum value in a column. (I want to be able to do a...

Hi everyone, I have seen explanations regarding how to present variations on Pivot Table, but none using some many fields as I need. This is the information that I have: <tbody> Restaurant Year Month Date N.º Persons Lunch Sales Lunch Average sale lunch N.º Persons Dinner Sales Dinner...

I've built a pivot that displays a starting inventory value (row) and associated future sales orders by day (columns). Using the calculated field feature (excel 2013), I can show the remaining inventory on any day specific to the inventory base. However, what I'm really trying to do is...

Need help please with a Calculated Field in a pivot table using a Pivot Table Grand Total in the formular. Example: Acme Corp purchased 3 items from ABC Co and received three invoices (A01, A02, A03) form ABC Co for those items. Below is a link to dropbox where I have the pivot table and...

Hi Guys, I have about 600 rego numbers for which I need to figure out below. 1) Difference between minimum & maximum odo reading for unique rego numbers 2) Days between minimum & maximum odo reading for unique rego numbers Below is an example of my data with 4 rego numbers I thought Pivot...

I'm using Excel 2013 and I have created a few dashboards using Pivot Tables. I have included a few slicers so that the pivot table becomes interactive in the hands of the end user. So far, so good. My problem is that in the case of dashboards which show tables with current year figures versus...

Hi, thanks for reading. I'm editing several supplied spreadsheets which have been compiled from many horrible locations. There is a format diffefence in the main sheet (i cant clear it with Shift Ctrl * or format paste) It is causing my pivot table to return multiple values for the same item...

All, I am seriously wrestling with this, and am hopeful you can help. My data set is pretty simple. I have as my pivot, theRegion and the facility as the data, and have listed a count of invoices presented for payments, and also a count of invoices that have been delayed. I would line to add...