How to get sum of columns of a list web part
Question
-
I added a list web part on a web part page and added Text filters connected to this list web part. I want sum of columns after the list is filtered, like the picture below.
I then have to use these values to show calculations like
If sum of col 1 > 0, sum of col1 + sum of col2.
How can I achieve this?
Answers
-
Hi,
According to your description, my understanding is that you want to get sum of columns of a list web part.
You can set properties of totals in the list web part via modify view.
1, Click the list ribbon in the list web part and select modify view.
2, Set properties of totals as below picture.
3, Click OK.
Best Regards,
Andy Wu
TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.
- Proposed as answer by Andy JY Monday, July 25, 2016 1:16 AM
- Marked as answer by Wendy DZMicrosoft contingent staff Friday, July 29, 2016 9:35 AM
