Announcements
Hi All,
I have a data table with a bunch of values and i need to use the sum of the data in columns, is there a way to create a SUM row? or is there a way for me to do it within powerapps or flow that doesn't involve me defining the sum for each column with its specific name? there is quite alot of columns and prefer not to write them all out
example data table
Hi @BlessedCobba,
If you need to sum up other columns/fields in the same row then yes you can with Calculated columns.
If you need to sum up columns from different rows, then the question is where would you store the sum? If a parent table/entity then you can leverage rollup columns.
Hope this helps!
Thanks @EricRegnier its something i want to store & use on demand, ive never used the rollup columns before nor how to use the parent table entity but i will investigate and let you know how i get on
Cool, but you might not need rollup is you want to sum up column from the current row. You should use calculated columns 🙂
Rollup fields will only calculate the values on intervals of 12 hours so if you change your data it is not real-time for these calculations (https://docs.microsoft.com/en-us/powerapps/maker/data-platform/define-rollup-fields). I just want you to be aware of this before you go down that path.
Overall when I get into doing analytics on the data in Dataverse it is usually much better to look at utilizing other tools to assist with this. Examples:
1. Excel Template - Utilize Excel Template to pull the data from your view and to create pivot tables, charts, etc. (https://docs.microsoft.com/en-us/power-platform/admin/analyze-your-data-with-excel-templates)
2. Power BI - This is my go to! 🙂 Power BI will let you slice / dice the data in many different ways based including time intervals, based slicers based on other fields in your tables, etc.
Overall Rollup fields for me has been a love / hate feature (but more hate) so I thought I would give you some more options.
Hope this helps. If answers your question please accept or helps in some way, please Like.
Thanks,
Drew
Hi both,
Thanks for the advice, i created some roll up columns but yes the intervals didn't really serve my purposeI did however solve the problem i was after by simply unpivoting the data which allowed me to filter and sum the data in way i needed within powerapps!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 387
timl 340 Super User 2026 Season 1
Vish WR 301
