I have a parent list that relates to three child lists. I want to show the subtotals of all the list items when looking at the parent list. I have added three fields to hold the subtotals of the child lists.
What is the best way to get the subtotals?
I have tried to get the "total" from the list control but I am having trouble isolating the total in the dom.
I have considered using pnp to query the child lists and get the totals, but that doesn't work on the New form.