AGGR Sum Function does not display for each Row

[brettaustin]

Hello Qlik!

I am trying to create an AGGR Summary table of the total representatives located by region by their department where they represent greater than or equal to 50% of the entire organization department.

For Example EU has 30 reps for distribution out of 37 total for the 'Deptlvl4' column.  

Deptlvl2	Deptlvl4	Region	Reps	Grand Total	T/F
Build	Distribution	AP	2	37	False
Build	Distribution	EU	30	37	True
Build	Distribution	NA	5	37	False

However I am unable to get Qlik to display/process the data correctly.  It will display 'Nulls' for 2 of the 3 rows.

Qlikview Table (see attached for example)

Deptlvl2	Deptlvl4	Region	Reps	Grant Total	T/F
Build	Distribution	AP	2	37	FALSE
Build	Distribution	EU	30	-	FALSE
Build	Distribution	NA	5	-	FALSE

[edwin · Accepted solution]

add a nodistinct to the aggr:

Aggr(nodistinct Sum({1<
Deptlvl4 = {"*"}
>}
[Total Reps])
,
Deptlvl4)

[brettaustin]

Thank you Edwin!