Skip to Content
0
Former Member
Jun 03, 2008 at 08:01 PM

Help neededon counting multiple occurrences of several items in a column...

886 Views

I am new to Business Objects and just completed the initial training. I am building my first BO report. The BO report has document numbers in the first column, and various information about the report across each rows. One particular column lists departments that each report is currently assigned. I need to count the number of documents assigned to each department. It would look something like this:

Doc_No--


Doc_Name
Date_Created
--


Dept_Assigned

ABC111--


Test Specs
1/1/08
--


Test Department

ABC112--


Calibration
3/8/07
--


Quality

ABC113--


New Hires
3/6/05
--


Human Resources

ABC114--


Measurements -10/2/06 --


Quality

ABC115--


Fix It Right
11/21/02
--


Repair

ABC218--


Check It Right-- -12/12/07 --


Quality

ABC219--


Retesting
2/29/08
--


Test Department

So when I am done, I would get a count like this:

Quality 3

Test Department 2

Human Resources 1

etc.

Will someone help me with the formula. This is definitely not like Excel!

Thanks,

Charles Norman

Edited by: Charles Norman on Jun 3, 2008 11:18 PM