Search results for query: *

Hello, I'm trying to Count a range of cells (ex: Col C) that starts with "ABC" if it's in a certain month or date range (Col B) I have a helper column for the dates, so if Col A is = January 5, then Col B = 1, Col A = February 13, then Col B = 2 etc. Sample Data would look like this: Col...

Hi there, I have a Cross-Tab set up that has a list of store location #'s by row and then a list of accounts across the columns. It is totaling up the number of transactions by count and $sum of each each store # to each account The count/sum of transactions fields are made up of 4 txn types...

Hi There, I'm trying to create a formula that will look at a cell value then run that value against a list and return the description of the corresponding value. I think this has to do with a look up function. Ex: My main worksheet is sheet 1, and I would like the column P to take the value...

Hi there, I'm trying to create 4 different columns that would show me the Count records and Sum of the dollar values between specific $dollar ranges. Ex: record 1 = $10.25 record 2 = $30.00 record 3 = $0.21 record 4 = $55.00 record 5 = $101.00 I need to create 4 different dollar ranges...

Hello, Wondering if its possible to create a formula that will take a cell in one sheet and reference a column in another sheet then return a value in that row if the cells match. For example: In Sheet A - cell A1 will take the value in B2 then check all the values in Column A in Sheet B to...

Hi there, Sorry this has been posted a lot, couldn't find one that I could use as a template. Need to sum up $value on only one record which are duplicated. Ex: Group1 - (Transit) ABC Group2 - (App#) 123 Detail (App#)123 - (Transit) ABC - $1,000 (App#)123 - (Transit) ABC - $1,000 (App#)123...

Hi there, I have a bunch of customer ID's that lists their account #'s along with the product code. I'm grouping by Customer ID and would like to filter out the group if that customer holds a specific product. I.,e GH1 - 123 123 - 3214 - ABC 123 - 4567 - CTE 123 - 4581 - SER GH1 - 456...

Hello, I'm trying to format a cell that is referencing another cell in another sheet, to round to the nearest 1,000 and add 'M' to the end of the number. For example, B6 in my primary sheet is referencing B6 in my Data sheet (=Data!6). It currently shows a currency amount, ex; $387,691. What...

Hi there, Sorry for the redundant post I realize this is a pretty well known issue. Tried to Google some solutions but wasn't able to resolve getting the % sign to appear in a bar chart that I have created from a cross-tab. My cross-tab consists of a grouping of age groups that I created a...

Hi, I'm wondering what the best way to format an excel field that has date format as mm/dd/yyyy to so that crystal reads it as a date field and not date-time or string? I've tried 'text to columns' making the field a date field, but crystal reads it as a date-time. Reason being, I would...

Hi, I have data that shows: Account# - Type of Product Any account# can have multiple product types in it, so my data will show repeated acct# with different products assigned to that acct# I've grouped the data by acct# and did a Count on products per acct#. I have then created a formula...

Hello, I'm trying to get a percentage of a summarized field that is grouped by month by another summarized field that is group by month. (Would like to get the %Worked column below) Ex: Gr.by.month Dist_Cnt_Apps Dist_Cnt_Apps_wrkd %Worked Jan 150 25...

Hello, I would like to group by quarter, however, I would like to have the quarters be from, Q1=Nov-Jan, Q2=Feb-Apr, Q3=May-July, Q4=Aug-Oct. I'm currently only using 3 fields, date field, product field and product channel field. Any help would be great. Thanks!

Hello, I would like to create a secondary axis for only 1 of the horizontal groups in my excel bar chart. Ex: Y-axis is dollar amount; X-axis I have 5 different columns, 1) Total $amt, 2)avg $amt, 3)max $, 4)min $, 5)$std dev. Each x-axis column is comparing values for A and B. My problem...

Hi there, I'm wondering if there's a way to suppress or hide a group but only on certain conditions? Ex: GH1 - [Issuer Bob] GH2 - [Client] [count of cert#] D - [Issuer] [Cert#] [Acct#] [Boolean for type of cert] [Client#] [lastname client] [first name client] GH2 - [Client] [count of cert#]...

Hello, I'm currently connecting to a data cube through the SQL Server Analysis Services using Excel 2007 but would like to access the same cube with Crystal. Not exactly sure if it is possible to create the same connection with crystal or if I have to connect using ODBC? Any thoughts would...

Hello, I'm wondering if I could get help in creating a drop down in one cell that when you select an item in the that drop down, it will change what appears in the next drop down. Ex: Cell A1 has drop down with a list of key words. If I select the first key word in that list. I will get a...

Hello, I've created a drop down in sheet one from a list in sheet two and I am wondering if it is possible so that when you start to type something like the letter "P" into the cell with the drop down, the list will auto populate to the section of the list with all entries starting with "P"...

Hello, I'm wondering if there's a way to count a formula. For ex: I made a formula saying return "1" if (field1/field2) >0.2. So the formula worked but now I would like to count all the '1' in each group. Thanks!

Hi, Just wondering if anyone has figured out a way to work around sorting a running total? Here's an example of what I would like. I have 2 groups Group 1: CustomerID Group 2: Date Within group 2, there may be 1,2,5,10,etc dates. I used a running total to count the number of dates in...