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.

 

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?

Thanks!! It solved my issue.