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.