Home

Use total from list on another page

%3CLINGO-SUB%20id%3D%22lingo-sub-1054725%22%20slang%3D%22en-US%22%3EUse%20total%20from%20list%20on%20another%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054725%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20a%20simple%20list%20in%20which%20i%20keep%20track%20of%20projects%20and%20the%20amount%20of%20hours.%20The%20list%20shows%20the%20totals%20of%20the%20hours%20and%20amount%20of%20money%20i%20have%20to%20invoice.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20have%20a%20kind%20of%20a%20dashboard%20page%20which%20shows%20these%20totals%20(and%20perhaps%20later%20some%20other%20totals).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20is%20it%20possible%20to%20show%20totals%20of%20listcolumns%20on%20another%20page%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehenk.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1054725%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054809%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20total%20from%20list%20on%20another%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054809%22%20slang%3D%22en-US%22%3EThere%20are%20no%20out%20of%20the%20box%20webparts%20to%20do%20this.%20I%20would%20use%20Power%20BI%20abd%20embed%20in%20the%20page%2C%20you%20can%20use%20a%20SharePoint%20List%20as%20a%20data%20source.%20You%20will%20be%20a%20Power%20BI%20licence%20if%20you%20don't%20have%20an%20E5%20and%20for%20any%20other%20users%20who%20want%20to%20view%20the%20webparts%20on%20that%20page%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054839%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20total%20from%20list%20on%20another%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180%22%20target%3D%22_blank%22%3E%40Alan%20Marshall%3C%2FA%3E%26nbsp%3BHi%20Alan%2C%20thnx%20for%20your%20respond.%20When%20you%20say%20'you%20will%20be%20a%20Power%20BI%20licence'%20you%20mean%20i%20need%20to%20purchase%20a%20Power%20BI%20License%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20now%20have%20a%20Office%20365%20Business%20Essentials%20license.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054991%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20total%20from%20list%20on%20another%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481859%22%20target%3D%22_blank%22%3E%40prins063%3C%2FA%3E%26nbsp%3Byou%20would%20need%20a%20Power%20BI%20Licence%20as%20that%20is%20not%20in%20the%20Business%20Essentials.%3C%2FP%3E%3CP%3EHaving%20given%20it%20some%20more%20thought%2C%20you%20could%20also%20export%20to%20Excel%20and%20then%20add%20total%20row%20to%20the%20table.%26nbsp%3B%20You%20would%20need%20to%20manually%20update%20the%20Excel%20file%20when%20you%20view%20it%20but%20can%20still%20embed%20in%20a%20page%20using%20the%20embed%20document%20webpart%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055766%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20total%20from%20list%20on%20another%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180%22%20target%3D%22_blank%22%3E%40Alan%20Marshall%3C%2FA%3E%26nbsp%3BThnx%2C%20i%20will%20give%20a%20try.%20Is%20the%20'manually%20update'%20something%20i%20can%20achieve%20using%20Microsoft%20Flow%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1056293%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20total%20from%20list%20on%20another%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1056293%22%20slang%3D%22en-US%22%3EThere%20is%20no%20data%20refresh%20action%20for%20the%20Flow%20Excel%20connector.%3CBR%20%2F%3EYou%20could%20also%20use%20a%20Power%20App%20but%20getting%20a%20large%20list%20will%20require%20the%20use%20of%20a%20collection%20and%20multiple%20retrievals%20to%20get%20the%20correct%20totals%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1066400%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20total%20from%20list%20on%20another%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1066400%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180%22%20target%3D%22_blank%22%3E%40Alan%20Marshall%3C%2FA%3EThnx!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
prins063
New Contributor

Hi,

 

i have a simple list in which i keep track of projects and the amount of hours. The list shows the totals of the hours and amount of money i have to invoice. 

 

I'd like to have a kind of a dashboard page which shows these totals (and perhaps later some other totals). 

 

So is it possible to show totals of listcolumns on another page?

 

Thanks in advance?

 

henk.

6 Replies
There are no out of the box webparts to do this. I would use Power BI abd embed in the page, you can use a SharePoint List as a data source. You will be a Power BI licence if you don't have an E5 and for any other users who want to view the webparts on that page

@Alan Marshall Hi Alan, thnx for your respond. When you say 'you will be a Power BI licence' you mean i need to purchase a Power BI License?  

 

I now have a Office 365 Business Essentials license.

@prins063 you would need a Power BI Licence as that is not in the Business Essentials.

Having given it some more thought, you could also export to Excel and then add total row to the table.  You would need to manually update the Excel file when you view it but can still embed in a page using the embed document webpart

@Alan Marshall Thnx, i will give a try. Is the 'manually update' something i can achieve using Microsoft Flow?

There is no data refresh action for the Flow Excel connector.
You could also use a Power App but getting a large list will require the use of a collection and multiple retrievals to get the correct totals
Related Conversations
SharePoint Modern Page custom column layouts
Lance Alcabasa in SharePoint on
3 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Remove the command bar on a List Web Part
Christophe Humbert in SharePoint on
1 Replies
Issue scroll pages
Marco Mangiante in Discussions on
9 Replies