I'm using Crystal XI.
Creating chart challenge. Can't figure how.
I have INPUT DATA sample, REPORT looks sample and CHART CHALLENGE requirements.
Need help.
INPUT DATA
columns:
code week1 week2 week3 week4 week5 week6
sample rows of data:
AA 20 30 23 24 31 42
AB 22 31 22 21 34 45
...
REPORT
group header:
code week1 week2 week3 week4 week5 week6
details:
AA 20 30 23 24 31 42
AB 22 31 22 21 34 45
...
group footer:
'TotalCount'(regular sum of week amounts)
'CalculatedTotal'(calculated using formula that includes 'TotalCount')
CHART CHALLENGE
one axis should be list of: week1, week2, week3, week4, week5, week6
another axis 'CalculatedTotal'
Hope this makes sense.
Problems: 'CalculatedTotal' is not on the list of available sources in Chart Expert. Plus value should come from multiple columns(week1, week2,..).
Creating chart challenge. Can't figure how.
I have INPUT DATA sample, REPORT looks sample and CHART CHALLENGE requirements.
Need help.
INPUT DATA
columns:
code week1 week2 week3 week4 week5 week6
sample rows of data:
AA 20 30 23 24 31 42
AB 22 31 22 21 34 45
...
REPORT
group header:
code week1 week2 week3 week4 week5 week6
details:
AA 20 30 23 24 31 42
AB 22 31 22 21 34 45
...
group footer:
'TotalCount'(regular sum of week amounts)
'CalculatedTotal'(calculated using formula that includes 'TotalCount')
CHART CHALLENGE
one axis should be list of: week1, week2, week3, week4, week5, week6
another axis 'CalculatedTotal'
Hope this makes sense.
Problems: 'CalculatedTotal' is not on the list of available sources in Chart Expert. Plus value should come from multiple columns(week1, week2,..).