Notifications
Announcements
ClearCollect( tempCollection, //Name of temp collection AddColumns( GroupBy( YourDataSet, //Reference to Your Collection Client, // First group Column Distributor, //Second group Column Month, //Third group Column Groupeddata //Column with grouped data -- ), SUM, //Name of newly added column where Your summed data will present Sum( ThisRecord.Groupeddata, Quantity ) ) )
ClearCollect( colInterm, AddColumns( colTest, ClientDistributor, Client & Distributor ) ); Clear(colResults); ClearCollect( colDistinct, Distinct( colInterm, ClientDistributor ) ); ForAll( colDistinct As X, With( { ClientValue: LookUp( colInterm, ClientDistributor = X.Value ) }, Collect( colResults, { Client: ClientValue.Client, Distributor: ClientValue.Distributor, Month: ClientValue.Month, Quantity: Sum( Filter( colInterm, ClientDistributor = X.Value ), Quantity ) } ) ) )
ClearCollect( testowa1, //Name of temp collection AddColumns( GroupBy( TempCollection1, //Reference to Your Collection Client, // First group Column Distributor, //Second group Column Groupeddata //Column with grouped data -- ), JAN, //Name of newly added column where Your summed data will present Sum(Filter(ThisRecord.Groupeddata, Month = "Jan"), Quantity ), FEB, //Name of newly added column where Your summed data will present Sum(Filter(ThisRecord.Groupeddata, Month = "Feb"), Quantity ), MAR, //Name of newly added column where Your summed data will present Sum(Filter(ThisRecord.Groupeddata, Month = "Mar"), Quantity ) ) )
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 840 Most Valuable Professional
Michael E. Gernaey 332 Super User 2025 Season 2
Power Platform 1919 275