Answered

AddColumns - GroupBy - SharePointlist

(0) Share

Report

Posted on by vidarv

I have a formula that counts number of indikators and sum values. The formula is working, but I can't figure out how to place the Year on top for each count and sum.

AddColumns(
 GroupBy(
 colAktivitetPrAar;
 "År";
 "Indikator";
 "alle_objekter"
 );
 "antall_indikator";
 CountRows(alle_objekter);
 "sum_antallKontakter";
 Sum(alle_objekter;AntallKontakter)
 
)

2022 2023

Indicator1	12	3679	14	6000
Indicator2	3	23	15	45
Indicator2	11	3697	11	5000

Can somebody Please help me ?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@vidarv Can you show a screenshot of the result of u'r formula?

Was this reply helpful? Yes No
vidarv on at

Like (0)

Report
Copy link

Link copied!

@CNT Thank you for answering

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@vidarv You have to wrap the whole thing in another GroupBy(......,"Ar", "ArGrroup")

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
vidarv on at

Like (0)

Report
Copy link

Link copied!

@CNT Can you show me an example ? Not sure what you meant.

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@vidarv

GroupBy( AddColumns( GroupBy( colAktivitetPrAar; "År"; "Indikator"; "alle_objekter" ); "antall_indikator"; CountRows(alle_objekter); "sum_antallKontakter"; Sum(alle_objekter;AntallKontakter) );"År";"ÅrGroup" )

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
vidarv on at

Like (0)

Report
Copy link

Link copied!

@CNT Do you mean two gallerys ? Your example will give me the year only ?

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@vidarv No! This is a nested Group. The Year in the outer Group and then the other stuff inside. How you want to display it is up to you - in a nested gallery for example.

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
vidarv on at

Like (0)

Report
Copy link

Link copied!

@CNT Ah you meant using the ÅrGroup and then concat , since ÅrGroup is a table. Thank you.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@vidarv

Glad to help!

Was this reply helpful? Yes No