How to aggregate based on hierarchy

[shruthibk]

Hi all,

i am facing an issue while aggregating data based on hierarchy.

Requirement is like there are level 1 to level 4 managers and there are some issues assigned to them,i have to build a chart where it shows the issues count under each employee.

The challenge i am facing is whenever the user selects level for ex.if user selects level 4 total issues assigned to each employees should show but when user selects level3 ,the counts of level4 employees should show under level 3 managers same way for level2 and level1.

attaching the screen shot of data after hierarchy implementation .

thanks

shruthi

[sunny_talwar]

Not entirely sure I understand your scenario... Do you have a sample you can share with expected output?

[shruthibk]

hi expected output should be without filter

empnames,count

deepak,2

ashok,2

vikash,2

shubham,2

gupta,2

shruthi,2

if the user selects level3  expected output:

empnames,count

deepak,2

ashok,2

vikash,4

shubham,4

if the user selects level2

empnames,count

deepak,2

ashok,10

[sunny_talwar]

Sounds good about the expected output.... but are you able to share a sample. Images are not very helpful to work with

[shruthibk]

i don't see any excel attachment option here:(

below is the sample data,which looks exactly as the actual data i am working

issueid	empnames	levels	level1	level2	level3	level4
12	Deepak	1	Deepak
13	Ashok	2	Deepak	Ashok
14	vikash	3	Deepak	Ashok	vikash
15	shruthi	4	Deepak	Ashok	vikash	shruthi
16	gupta	4	Deepak	Ashok	shubham	gupta
6	shubham	3	Deepak	Ashok	shubham
43	Deepak	1	Deepak
78	Ashok	2	Deepak	Ashok
7	vikash	3	Deepak	Ashok	vikash
5	shruthi	4	Deepak	Ashok	vikash	shruthi
1	gupta	4	Deepak	Ashok	shubham	gupta
42	shubham	3	Deepak	Ashok	shubham

[shruthibk]

attached the sample data