value field setting

Hi, I have individual calls for a call center. I created a pivot table with total volume listed by Date. I have grouped the dates to show this only as months. I would like to have a column showing change of volume month over month but i keep getting an error. Notes: My Monthly Volume column...

Hello, I have a pivot table. When using the 'Count' values field setting, my table is picking up blank cells as well from the original column. The formula is that if the data is 0 or error, to return " ", and if the returned value is < or > X, to return 1 or 0. I want the pivot table to only...

I have data in a Pivot Table that I’m showing Sales by Quarter and Total Sales (Column) and Sales Rep (row). I want to show whether or not the Sales Reps have made the quarterly quota, and whether it’s below or above the quota, and the percentage of the how far away from the budget it is...

when do we do of % of column and when % of row in value field setting

Im looking for something very simple just to replace the field data of one field based on the entry of another. I used to know VB, not so much anymore, so here is a poorly written, multi lingual script that shows in essence what im looking to do, any/all help would be appreciated: Fields...

Hi, I just put a pivot together which had values for every day of the month for the last 6 months... Think of it as the values of 4 or 5 stock prices being tracked on a daily basis over the past 6 months for 5 clients or something... Once I was done with bringing down the sum of around 180...

From the research I've done, it seems that pivot tables do not support text in the values area, period. **** this is frustrating! :eeek: Quite a bit of work has gone into aggregating this data, and it's so close, but the text fields are showing 0. Have a look. Double-clicking on cell C5 (sheet...

I am not sure what I am doing wrong but I am trying to get my pivot table to show the difference from the previous year. I keep getting #N/A I can get it to work by month but not year. My column is named NUMBER Value Field Setting - SUM OF NUMBER Show values as - DIFFERENCE FROM Base Field...