Fairly new to crystal but can usually figure/find a solution somehow.

 

Not for this issue yet. I've got a report that I need to group by dollar increments (<20000, >50000 and between 20-50000)

 

I needed to create a formula to get the total value for each individual.

 

I dont see how I can group them by the formula field. When I try to insert a group I only see the report fields not any formulas I can select.

 

Is there a way to group by the results of my total formula?

Sum ({vwsrt_SourceMarket.SourceTotalMarket}, vwsrt_SourceMarket.par_ssn} )

 

 

 

Bummer.

 

I initially tried the Top n route but it wasnt getting me exactly what I needed.

 

I'll see if I can get the total from another source or try outside crystal.