Hi Guys,
I would like to know if there is a way to summarize a column by getting the totals at the end in a list within one cell of another list that has a master detail relation ship. If this is unclear, I shall elaborate.
Take for instance, a table with Order Lines of a single order. These order lines have multiple items in each line. I have one column in this list that shows order items and their individual quantities that has a master detail relationship with the Order Line. I want to get the totals on this list of every Cell in order_line to show up at the bottom of the list or at the bottom of the entire column. If it is possible, how may I achieve it?
I hope it wasn't too unclear. your advice is highly appreciated!