Jump to content

Summary field from other table


This topic is 2797 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello all,

 

I am having two tables, Customers and Orders.

 

My layout has : 

-List view of Customers

-Leading grand summary part in which I want to show summary of total orders.

 

When I show all records, I get correct figure of total orders of all customers.

But when I filter records, the summary field present in leading grant summary of total orders does not change.

 

Is there any way so that I can view filtered data in summary filed that is located in other table?

for more info, attached screenshot.

 

Any help will be appreciated.

Thanks.

 

post-110480-0-22385500-1428304796_thumb.

Link to comment
Share on other sites

If by "filtering" you mean performing a find in the Customers table, and you want to see a value summing all orders related to customers in the current found set, you need to define a calculation field in the Customers table =

Sum ( Orders::Amount ) 

and a summary field totaling this field. This is assuming you have a proper one-to-many relationship between the two tables; this point is not clear, since what you describe as working, should not work.

 

 

--

P.S. Is your other question answered?

Link to comment
Share on other sites

This topic is 2797 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.