Solved

Summing up list items in SharePoint online and a bit more

Posted on 2016-10-27
5
26 Views
Last Modified: 2016-11-01
I am actually trying to tackle three related problems related to reporting of sales figures.

1. Individual users need to post their individual numbers, so how can I have a form that relates just to their numbers?  
2. These daily numbers need to be summed into a total.
3. The daily totals need to be summed into monthly, quarterly and annual totals.  Want to display all of those in Power BI.

Would a separate list for each user solve #1?  How would I create the totals for both #2 and #3?

BTW, this is all for SP online.
0
Comment
Question by:lmheimendinger
  • 2
  • 2
5 Comments
 
LVL 14

Expert Comment

by:SneekCo
Comment Utility
You could use a common list, but provide each user with a filtered view so that they only see their own data. This is not recommended is the data should be very secure and/or the users should not see the other user's data. But if it not secure, this approach is not a bad way to do it.

Good luck...
0
 

Author Comment

by:lmheimendinger
Comment Utility
Thanks.  IS a filtered view the same as a custom view?  Exactly how do I make is specific to the logged in user?  

Any ideas on how to create the summations?
0
 
LVL 14

Expert Comment

by:SneekCo
Comment Utility
You can filter a view under "Modify View" settings of the list. The filter would be [ME] so that the logged-in user only sees their items.
0
 
LVL 10

Accepted Solution

by:
Michael Vasilevsky earned 500 total points
Comment Utility
You can create summations out-of-the-box by editing the View: Settings -> Edit View -> Totals

You can also use Group By to get totals by month, quarter, and year.

Hope this helps!
0
 

Author Comment

by:lmheimendinger
Comment Utility
Thanks I will try that and let you know.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Steve Terp was featured in a video created by CRN about how "Channel Is Crucial To Market Disruption". Click on View source to see the video and article
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now