quick 500pts...Crystal report count an item in details

So I have a CR that shows in the details pane:

Day 1  Item code                
            AU
            CN
Day 2
           AN
           AU
           CN
Day 3.......

I need to produce this summary:

Code          Days in Service
AU               2
CN               2
AN               1
             

I would imagine it is a formula My brain is not functioning right now...
T
BKennedy2008Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
mlmccConnect With a Mentor Commented:
I agree this looks like a classic crosstab

What data do you have?

You cold try formulas like

If {Field} = 'AU' then
   1
Else
   0

You can then summarise it to get the days.

How many values are there?

mlmcc
0
 
BKennedy2008Author Commented:
Oh and Code is grouped together daily.
0
 
vastoCommented:
Looks like a simple cross-tab. Did you try to create one ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.