I do not believe this will work. I'm am looking at YTD as opposed to current and last month.
I have the Monthly summ Ok. The next column would be a cumlative of the current month and the previous month(s)
so..
Jan2010
Cust Mthy Cuml
CstA 5000 5000
CstB 7000 7000
CstC 9000 9000
Feb2010...
I am summarizing Customer and Ammount grouped by month. I would like to an additional summary on the ammount that is a cumlative of current and previous months. I am tring the running totals but can't get it to work right.
Jan2010
Cust Mthy Cuml
CstA 2300 2300
CstB 1900 1900
CstC 1100...
To answer your 2nd question..yes.
Your first question...
The data is derived from call-center tracking.
There is a created_dttm field and a closed_dttm field. The objective is to report the percentage of casses closed in 2 days. My formula named ClosedInTwo:
/////////////////////////////...
I tried and the graph showed the data in the "returned" column below.
I put the date field under "On change of"
Under show values I added my data field as sum and selected Percentage of sum.
The data consists of 1's or 0's
So on month 9 has 24 items with 16 1's...should return 67 but returned...
I'm having trouble understanding how to get Crystal Reports 11 to display a percentage chart. I could do this 10 different ways with my eyes closed in Excel but CR is giving me a fit.
Essentially it is a count of records meeting a condition divided by the total count. Need single bar for each...
Hi,
Just joined the forum...very good information.
Using CR 11 I am creating a graph with one series with a record count by month (for the last 6 months). I want to add another series with the average of all 6 months plotted for each month.
Using a formula fields I can get the average but...
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.