Is this possible where I have two lists - one is a claim form and the other is an authorisation amount. The results in the authorisation amount will contain a unique reference with a total amount that has been approved whilst the claim one will be individual claims with the refence number attached (links to the authorisation list)
What I want to do is create a third list with the unique reference (auth list) - authorisation value (auth list) - sum of all Claims (linked by unique reference - claim list)
Is that possible? if so, any ideas easiest way of doing it? I've been searching for sumifs in sharepoint but I'm a novice so any plain English guides will be much appreciated.
Thanks