web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to group 2 separat...

Power Apps

Unanswered

How to group 2 separate colums for Pie Chart

(0) Share

Report

Report

Posted on by GARYRU

65

Hi Guys, ,

I have been trying every thing to get this right but no success. I have a sharepoint list and I want to create a piechart using 2 of the columns. The first column is called Lender and is made up of various lenders , WBC,CBA,NAB ANZ etc. and then the other column is LoanAmount obviously with the various loan amounts. I can group the Lenders OK but then cannot get the loan amount to total per lender to show on the pie chart who our best lender is etc. Any help would be greatly appreciated.

Thanks

Gary

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
@GARYRU you can do this somehow like this way,
ClearCollect(GroupedData, AddColumns( GroupBy(YourSharePointList, "Lender", "LoanGroup"), "TotalLoanAmount", Sum(LoanGroup, LoanAmount) ) )

please check datasource name and column names.

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!
GARYRU 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for the reply. That formula doesn't work. These are the columns that I have in the list
This is how the formula shows:
The error says: Name isn't valid. 'LenderCountCollection' isn't recognized.

Join the conversation