Hi,
I have records like below
employeeId employeeName ParentId salaryData
1 Steve 0 Jan
2 Antony 1 Jan
1 Steve 0 Feb
and the expected result is
Steve
-
Jan
-
Feb
-
Antony(sub group)
-
Jan
for this i had used Hierarchical grouping(parent id with employee id and in customized group name i selected employeee name), but I'm getting output like
Steve
-
Jan
-
Antony (sub group)
-
Jan
Steve
-
Feb
Whats wrong in this, how to solve this
Please help me
Thanks