Summing up list items in SharePoint online and a bit more

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.
lmheimendingerAsked:
Who is Participating?
 
Michael VasilevskyConnect With a Mentor Solutions ArchitectCommented:
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
 
Walter CurtisSharePoint AEDCommented:
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
 
lmheimendingerAuthor Commented:
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
 
Walter CurtisSharePoint AEDCommented:
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
 
lmheimendingerAuthor Commented:
Thanks I will try that and let you know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.