I need the report like below chart .can any one please suggest how to do this.
|Manager||Reportee||Total Amount (Direct +Reportees)||Reportee Amount|
|X||A||100(A Direct Amount)+(Reportees 70+20+30)=210||110|
|A||B||40 + (Reportees 10+20) =70||30|
You need to post exel data as Arul said above.........I am putting my understanding below.
You need to take 2 Dimension 1) for Manager Field 2) for Reportee Field
And you have to take expression for calculating Reporting Amount:- Sum( Reportee) and have to take one more expression for calculating
Total Amount : Sum( Reportee) + Sum(Direct)
If any doubts then please post you QVW /RawFile/or Exel Data from where u are extracting as it does not clear much more information.