How to make Summary data

Like (0) Share

Report

Posted on 21 Jun 2020 13:46:19 by answeriver

110

Hi all.

I have app, where users make orders. Data Source is SharePoint List.

I need to make on main screen summary table. I try to make simple sum by column share point list with quantity of products, bu it's not allowed. I thought it's simple, but i was wrong.

Do you have any examples for this?

Categories:

General Questions

All responses (3)

Answers (1)

Verified answer

v-yutliu-msft on 22 Jun 2020 at 07:43:48

Like (0)

Report
Re: How to make Summary data

Hi @answeriver ,

Do you want to get sum of quantity based on product type?

If so, you need to firstly use GroupBy function to group rows based on product type, then use AddColumns and Sum function to add a column with the sum of quantity for each product type.

Could you show me your table's structure? fieldname, field data type?

I assume that you have a column named product(text type), a column named quantity(number type).

insert a data table, set its Items:

AddColumns( GroupBy(table,"product","products"), "sum of product", Sum(products,quantity) )

Best regards,
Rahber 1,935 on 21 Jun 2020 at 14:15:54

Like (0)

Report
Re: How to make Summary data

Can you try this?
Sum(Filter('Name of the List','Status'="Completed"),'column to be counted')
So basically i am using filter to delgate the stuff to sharepoint to get me the required rows and then i have counted the columns. I am using a filter Status is completed and you can change it to your filter
My column type was Number.

Please mark the post as solution if it resolved your problem or if it helped you in anyway don't forget to up vote!
mdevaney 29,987 Super User 2025 Season 1 on 21 Jun 2020 at 14:07:50

Like (0)

Report

Re: How to make Summary data

@answeriver

Please PROVIDE a sample of your data being used as an input for the summary. Then, show EXACTLY what the summary should look like.

The forums are most helpful when you ask a specific question.

---

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."