cross tabular summation

[priyadarshini.shaha]

Hi Good morning

 I am creating a jasperReport. I am working working 1st time on this.. very new to xml/jasperreport concept
My requirement is as below. I need cross tabular summation of few columns no_of_clerks,no_of_managers,no_of_peons against comapny, department, project.
I have written a ' group' in a jasper file for getting sum for 1 level. i.e. i have written 1 group that can create sum against either Company or Department or Project. I need to create a group inside a group. or is there any other way to do this?

Available data and required output is below. and also attached  

Available data        
Company Department Project floor clerks managers peons   
tbank Pune LoanSys 2nd 12 3 3   
tbank Pune LoanSys 3rd 15 4 3   
tbank Pune LoanSys 3rd 15 2 3   
tbank Thane LoanSys 2nd 12 3 3   
tbank Thane LoanSys 2nd 12 7 8   
tbank Thane personalloan 2nd 12 7 8   
tbank Thane personalloan 4th 12 7 8   
kbank bavdhan collection 4th 14 2 3   
kbank Kothrud collection 3th 14 2 3   
RBCbank Solapur collection 4th 14 2 3   
RBCbank Solapur collection 3th 14 2 3   
         
Required output        
tabnk pune LoanSys 2nd 12 3 3   
tbank Pune LoanSys 3rd 15 2 3   
tabnk pune LoanSys  27 5 6   
tabnk pune   27 5 6   
tbank Thane LoanSys 2nd 12 3 3   
tbank Thane LoanSys 4th 12 7 8   
tbank Thane LoanSys 24 10 11    
tbank Thane personalloan 2nd 12 7 8   
tbank Thane personalloan 4th 12 7 8   
tbank Thane personalloan  24 14 16   
tbank Thane   48 24 27   
tabnk    75 29 33   
kbank bavdhan collection 4th 14 2 3   
kbank bavdhan collection  14 2 3   
kbank Kothrud collection 3th 14 2 3   
kbank Kothrud collection  14 2 3   
kbank    28 4 6   
RBCbank Solapur collection 4th 14 2 3   
RBCbank Solapur collection 3th 14 2 3   
RBCbank Solapur collection  28 4 3   
RBCbank Solapur   28 4 3   
RBCbank    28 4 3 
 

Thanks in advance

P J S