Sum / Aggregate Only providing first value

[villegasi03]

Looking for some assistance with a similar post regarding sum product. I have had a similar problem as the post below but I have an additional dimension as he does not.

http://community.qlik.com/message/300618#300618

I am getting this Using (SUM(AGGR(SUM(Workload), Employeeid)) 😞

Employee	Workgroup	Answered	Handle Time	WG Workload	Global Workload
Employee, One	Workgroup1	173	374	64702	81,679
Employee, One	Workgroup2	15	314	4710
Employee, One	Workgroup3	47	261	12267
Employee, Two	Workgroup1	140	286	40040	122,210
Employee, Two	Workgroup2	61	931	56791
Employee, Two	Workgroup3	17	637	10829
Employee, Two	Workgroup4	50	291	14550
Employee, Three	Workgroup1	8	465	3720	14,340
Employee, Three	Workgroup2	24	320	7680
Employee, Three	Workgroup3	6	318	1908
Employee, Three	Workgroup4	3	344	1032

Woud like to get this:

Employee	Workgroup	Answered	Handle Time	WG Workload	Global Workload
Employee, One	Workgroup1	173	374	64702	81,679
Employee, One	Workgroup2	15	314	4710	81,679
Employee, One	Workgroup3	47	261	12267	81,679
Employee, Two	Workgroup1	140	286	40040	122,210
Employee, Two	Workgroup2	61	931	56791	122,225
Employee, Two	Workgroup3	17	637	10829	122,225
Employee, Two	Workgroup4	50	291	14550	122,225
Employee, Three	Workgroup1	8	465	3720	14,340
Employee, Three	Workgroup2	24	320	7680	14,340
Employee, Three	Workgroup3	6	318	1908	14,340
Employee, Three	Workgroup4	3	344	1032	14,340

[#2]

Attached with answer. I did a back-end calculation.

Thanks

AJ

[swuehl · Accepted solution]

Try

=sum(total<Employeeid> Workload)

[villegasi03]

IT WORKED THANK YOU SOOOOO MUCH

[srchilukoori]

AGGR will evaluate one value in this situation.

A workaround is to use Sum(total <Employee ID> [WG Workload])

[maxgro]

perhaps this?

SUM(TOTAL <Employee> AGGR(SUM([WG Workload]), Employee))