Search results for query: *

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

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

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

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

I have the below statement to sum the number of FTE's for a Job Function. I want to add an OR type condition to the below statement, so it is adding 2 or more Job Functions, for example Job_Function = "Business Consultant" or Job_Function = "Programmer". Thoughts on how...