I have a report reflecting two years. 2005 and 2009 sales by customers
Customers are the rows
Months are the columns.
as of now i have the report grouped by year, but i need to see each customer 2005 and below 2009
I have a data base with columns as follows:
Name year program jan feb march etc.
the year is from 2004 and to date
months are jan. to dec.
various programs as in program 1, 2, 3
i need to create a report sumarized by type of program with year 2005 and 2009 across and customer showing once...
I created two reports reflecting summary by customer / by quarter by year (2008 and 2009 qrt 1, 2 etc)
I did that since I was not able to have cross tab report reflecting 2008 1st qrt, 2008 2nd qrt to 2009 3rd qrt
Can I combine the two reports such I see one big report from Jan. 1st 2008 to...
I am having trouble reflecting on a report two years and the customer only once, Customer shows for both years:
Report should be like this:
should be like this:
Customer 1 year 2008 year 2009
it shows twice for each year
Thank you so much. It worked.
Now if the total sales is a zero, and total count of rows was zero, when I crate the average I get an error as a division by zer. How can I go around that?
Again, thank you so much.
I should and I am sorry I did not
I have a report reflecting sales by month in columns.
Rows represent name of customers.
I grouped the report by area.
From above, I inserted a runing total counting the rows. (representing how many customers had sales)
Now, I have to insert a formula were I...
Thank you so much. It did work.
Now I have to use an average. Each column has a total (sales) and need to devide the nr. of rows to the total sales.
Many thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.