Recent content by planopeets

Yes, I had noticed that problem. I do a lot of pivot tables, always have to change count to Sum. Great. Thanks. another question for you. I noticed that Pivot Tables Remember past data in the drop downs, even though the data doesn't exist in the new refresh, i..e pull from a text file which...

That worked. I always select the whole sheet when creating a pivot table. I guess that always places a blank in the list. Thanks

Basically I have fields Account, Date (MM/DD/YY) and Revenue. I want to create a privot table and have the revenue show by Qtrs. I can create the Pivot table with Account on the left, Revenue as the data and Date as the Row. But when I go to select the field Date to group, I get the following...

Thanks, I was selecting the raw data instead of the chart data series.

Below is the sample data: Qtr1 Qtr2 Qtr3 Qtr4 Project Revenue $12,820 $5,967 $4,549 $3,029 Presales $1,049 $5,014 $5,138 $3,348 Corparate Goal $13,803 $13,096 $12,856 $13,819 would want Project Revenue and Presales to display on top of each other in a bar, there...

Hi Skip, I'm stuck with how to select the series the has the line info, when I select it, the Chart option is not available.

I want to create a chart, with stacked bars by Qtr, i.e. Presales, booked revenue on top of each other on the bar. Then have a line going accross the top with Corporate Revenue numbers by Qtr. This would give a view how close or over we are for making the numbers. Getting the break down of...

Using Excel 2002. I have a spreadsheet in which data is imported on a weekly basis. Spreadsheet is basically a 12 month Revenue view. What I would like to do, is for Revenue Lines in a status of "Softbook", apply a percentage to the values of for those rows which have that status. So data...

Actually, I'm not getting the error anymore, but it does not appear to be using the condition of (OR(Type="Not Applicable",Type="Contractor")to only include these two types. =SUM((IF(OR(Type="Not...

Using the OR(Type="Not Applicable",Type="Contractor") did work. Thanks. Do you know why the Type={"Not Applicable","Contractor"}does not work in the formula, yet the Status={"Non-Bill","Loaner","NB-Commit"} latter in the...

The below formula, is producing an #N/A error in the cell, If I remove the "Contractor" from the selection critria, it works fine. It is not, "Contractor" causing the problem, since removing "Not Applicable" will also work fine. It is the fact I have mult values...

Thanks. The error I was getting was at the creation of setting up the Pivot table. By creating a Pivot table, then moving Sum of the Months to the Row, it got around my problem.

Below is a shot of the data,starting with Jul, that is the labels, then starting with $2,268, that is the first line of data, not sure how else to show you the data. I want to correct my previous, at a summary level we are looking at about 200 customers, but the data file has about 900 recs, so...

I'm using Office XP. Basically I'm looking for my pivot table to look like the following: Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Customer 1 $ $ $ etc Customer 2 $ Customer 3 $ etc. So for Rows we are talking a max of 12 - 14 depending on filter, the Customers in the...

I'm trying to create a Pivot Table, which lists the Customers in the left most column and the 12 months accross in a Row. The Pivot table needs to sum the revenue for each customer by Month. There are some other misc fields I'm adding to the mix. I get the following error message from excel...