Sub Summary value

[hwachai]

This is how I generate my report. I have 2 different table, one (Project) is for me key in the project, another one (Money) for user key in their expenses which link to the project I created. Below is the result i generated from the "Money" table..... each project have different group of people working on it.

 

My question, how can i get the value from 2 sub summary area? Which I can use on my Project table.

 

 

Project Toilet bowl                     $13000        <--------- I need this total value for each project

                       Team A                  $4000    <----- I need this total value from team A who work on this Project

                                Keany              $1000              2 hours           German

                                Susan              $1000              3 hours           Columbia

                                Kenny              $1000              1 hours           India

                                Monny              $1000              2 hours           Columbia

                       Team B                 $3000   <----- I need this total value from team B who work on this Project

                                Karry               $1000              6 hours           Sudan

                                Putra               $1000              4 hours           Columbia

                                Craig               $1000              3 hours           Denmark

                       Team C                 $5000

                                Susan              $1000              1 hours           Columbia

                                Peter               $1000              1 hours           Columbia

                                Piear               $1000              8 hours           Columbia

                                Aivan               $1000              12 hours           Columbia

                                Craig               $1000              4 hours           Columbia

                       Team D                 $1000

                                Benny              $1000              12 hours           Columbia

 

Project Washing Machine       $12000     <--------- I need this total value for each project

                       Team A                $5000

                                Kelly              $1000              6 hours           Columbia

                                Kent              $1000              7 hours           Nigeria

                                Bell                $1000              7 hours           Columbia

                                Xixily              $1000              8 hours           England

                                Niel                $1000              2 hours           Columbia

                       Team B                $4000

                                Kent              $1000              4 hours           Columbia

                                Xixily              $1000              2 hours           Malaysia

                                Vanny            $1000              6 hours           Columbia

                                John              $1000              12 hours         Taiwan

                       Team C                $3000

                                Kelly              $1000              8 hours           Columbia

                                Molly              $1000              8 hours           Columbia

                                Kent               $1000              4 hours           Columbia

 

1) getSummary(Cost;Project)    <---- I can get the total from the whole project expenses, but only work within same table. I can't link out the value to another table. Can I create a new record to another table based on this value?

 

2) any idea how can I get the Sum "Cost" from Project("Project Toilet Bowl") and Team("Team A")?

 

3) Possible to use the result inside the report? Most Important.... I need this value link to different table ... -.-" ....

 

Sorry for asking too many question, I hope my explanation is clear enough to understand.... Thanks!!!

 

 

hwachai ...

filemaker newbie

[hwachai]

using alternative way to achieve this.... portal filter and getObjectAttribute ... looking good so far!