AnsweredAssumed Answered

Question about Sub-summaries and Calculation fields

Question asked by MichaelKaufman on Jul 8, 2011
Latest reply on Jul 8, 2011 by MichaelKaufman

Title

Question about Sub-summaries and Calculation fields

Post

Imagine I have a table like this:

Cust  Number

Amount  Number

TotalAmount  Calculation Sum(Amount)

My table might have data that looked like:

Cust       Amount     TotalAmount

1            100            800

2            200            800

1            300            800

1            200            800

Now suppose I want to add a fourth field:

SubTotalAmount    Calculation

I want this field to contain the sub-total amount for each specific customer. So that my table would look like:

Cust       Amount     TotalAmount    SubTotalAmout

1            100            800                  600

2            200            800                  200

1            300            800                  600

1            200            800                  600

Is there a way to do this? 

Alternativly, if I create a table view with a subsummary area, is there a way to access the values in the subsummary area?

Thanks.

Outcomes