Count of all Records that are broken by section

building reports webintelligence
1

Hello Friends. Please help me . I have a required to add the sum of all the counts in different Section of the report
I have a report that have different sections by supervisor , Functional to item numbers so I am able to get the total of Item by Supervisor, but I am not able to add the sum of counts by Functional Area

=Count ( [Counter by Sup] In ([Functional Area])) In Report

I tried all this but it does not work

So my result shall be at top of report shall say like below

count for Functional area IT = 31
AND count for Functional area MFG = 19

Example

Section # 1
Function area = IT
SuperVISOR = JOHN
Count = 21

Section # 2

Function area = IT
SuperVISOR = Mark
Count = 10

Section # 3

Function area = MFG
SuperVISOR = Mark
Count = 11

Section # 4

Function area = MFG
SuperVISOR = jAY
Count = 8

Thanks

Soniya

soniyakaren (BOB member since 2009-07-21)

2

Insert a cell with the section - block.
use =Count([Counter by Sup])
Do relative positioning to these blocks for the alignment.

Arjun (BOB member since 2008-07-28)

3

Another option may be, insert a table(2 columns) on the top the report with [Functiinal Area] and Count([ItemNumber]). This will automatically propagate the number of items per Functional Area without considering supervisor.

Hope this helps.

Thanks
-Satish

forgotUN (BOB member since 2006-12-13)