1

List 1- Food

Jan Feb Mar Total
1000 1000 1000 3000
sum sum sum sum

This list is a category and lists 2-Clothes, 3-Water, 4-Internet, 5-Misc are the same I need the sum of the columns of this list to be transposed to the summary list

then summarize it all on a summary list:

Jan Feb Mar Total
10000 10000 10000 30000
10000 10000 10000 30000
10000 10000 10000 30000
10000 10000 10000 30000
10000 10000 10000 30000
sum sum sum sum

1 Answer 1

1

You cannot create a calculated column in SharePoint list based on data in another SharePoint list.


So, your requirements cannot be achieved using SharePoint OOTB functionalities. You need to develop the custom solution for this.

If you want to calculate it periodically & update it SharePoint, you can run scheduled power automate flow which will do the calculations & updated the data in summary list.


If it is not mandatory to show the summary report in SharePoint itself, you can create a canvas power apps application using the SharePoint data & do the calculation using power apps formulas.

4
  • that is what I am doing right now. I am trying to create a power automate flow for this. Aug 5 at 4:58
  • ok great. let us know if you need any help with it. Aug 5 at 5:03
  • Please Upvote(^) and accept as an Answer if it helped you in any way & it will help others with similar question in future to find the correct answer easily. Aug 5 at 5:04
  • I am stuck at sorting the array from each month column to perform a sum data operation. Aug 5 at 19:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.