Report Format

[svsudhakar]

Hi ,

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
A	c	20	0
A	D	30	0
B	E	10	0
B	F	20	0

[arulsettu]

can you post any excel data source

[svsudhakar]

Please find the attached sample data source

[svsudhakar]

Please fin the updated one

[sarfaraz_sheikh]

Dear Sudhakar,

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.

Thanks

Sarfaraz

[arulsettu]

can you check the updated excel is right one. because it contain only two fields

Manager

Reportee

thats all what about other fields

check it and update

[arulsettu]

i made a sample data find the attachment and let me know

[svsudhakar]

Hi Arul,

please check the second sheet. its having 2 sheets one is user data and other one is user wise values.

[svsudhakar]

Hi,

attached the qvw with sample data.

[arulsettu]

what about the Reportees