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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 93 Most Valuable Professional
Haque 81
Valantis 49