Hi,

 My requirement is like...

Suppose we have some data in table like

col1   col2   ManagerId Product   SalesDone

1        AA       null             p1         10

2.       BB       1                p2         20

3.       CC       1                p3         21

4.       DD        1               p2          3

Now if i show heirarichal data on the basis of col1 & managerId then it will show like this

-1       AA      p1       20

    2    BB      p2       20

    3    CC      p3      21

     4   DD      p2        3

Now my questions are

1. Can i show for manager the salesDone as (sum of manager sale + All Employee Sales ) at run time i.e. not by writing logic in Stored Procedure.

2. Suppose i drag Product column on Outlook Group By then CAN i see roll up data for that product for eg  in front of p1 i should see 20 & in front of p2 i should see 23 & in front of p3 i shopuld see 21. then the respective groupby rows under them. In other words can i see other columns as well for coulmns that are choosen for group by in outlook group.

Please let me know whether i can do this .

Thanks

Anurag