calculated fields

Hi, I'm working on a pivot table that gives me the average sales$ per adjustor for each branch within a Region. I created a pivot table that has the region as the row field, the month as a column field, Sales and # of salesmen as the value fields and a calculated field the calculates the...

I want to create a calculation representing Customer Satisfaction. I have customer survey data that contains a column called "Q1". This column contains 5 possible values, 1 through 5. The calculation for Customer Satisfaction (CSAT) is the total number of Q1 responses that are 4 or 5, divided...

I need to get the following formulas which are on a spreadsheet to translate into a calculated field in the pivot table. These two formulas work fine within the spreadsheet: {Original Working Spreadsheet Formulas} Formula 1: =GETPIVOTDATA("Sum of Standard Reimbursement Amt",$A$16,"Payor...

I know I'm going to feel really dumb about this when I find the answer - but here goes. Problem: I've got a database that consists all of my stock transactions for the last 20 years. The fields include: date, account, stock, activity, number of shares and cost per share. I've used a Pivot...

I am building pivot tables off a data table that includes orders for training events ('Order Table'). In this table each row signifies 1 order. Each event has a unique event ID, so in this table there are usually several rows for the same event (1 for each order the event had). For each order...

Hi I have a query which I am trying to get a count of all activities. The query is grouped by the field of Office. There are then fields called Engagement, On Site, Off Site, Visiting and Admin. I have created a new field called Total Activity Count and used a calculated field to add these...

Hi, I have a pivot table with a number of calculated fields. I want to create another table on a different tab that will still have access to the calculated fields. I need ready access to several perspectives without having to rearrange the same table constantly. In the "old" excel world...