Tattwam Posted April 6, 2015 Posted April 6, 2015 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. Â
comment Posted April 6, 2015 Posted April 6, 2015 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?
Recommended Posts
This topic is 3808 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 accountSign in
Already have an account? Sign in here.
Sign In Now