Hi everyone, I'm new to using cross tabs in crystal reports. Basically, there is a cross tab that I'm trying to build but can't seem to get it to work. Here is a rough idea on the output I'm looking for.
--------------------------- Product A ------------------------
Successful Sales Total Prospects Success Rate
Sales dealer1
Sales dealer2
Sales dealer3
Region Total
Sales dealer4
Sales dealer5
Sales dealer6
Region Total
Country total
My question is... how do I get the figure for the last column? The success rate is the "successful sales" column divide by "total prospect" column.
Edit: Oh, I'm using Crystal Report 10.
Edited by freestylepunk - 05 May 2011 at 9:48pm
IP Logged