GroupBy Function to Summarize Sales & Sort Chronological based on Fiscal Months Calendar in Excel 365
Rahim Zulfiqar Ali
![Rahim Zulfiqar Ali]()
Rahim Zulfiqar Ali
Founder & CEO Excel Basement, Excel, POWER BI, Python Trainer & Consultant, MBA (MIS), Microsoft Certified Trainer MCT, Emerging Data Scientist | 194K Followers
GroupBy to Summarize Sales via Months & Sorted Chronological based on Fiscal Months Calendar in Microsoft #Excel 365
=SORTBY(GROUPBY(Data[Months],Data[Sales],SUM,,0),MATCH(CHOOSECOLS(GROUPBY(Data[Months],Data[Sales],SUM,,0),1),Fiscal_Months,0))
Top 3 Months & Sales Sorted!
=SORT(FILTER(B6#,C6:C17>=LARGE(C6:C17,3)),2,-1)
GroupBy to Summarize Sales via Month & Sorted Chronological based on JAN-DEC Calendar in Microsoft Excel 365
=GROUPBY(--(1&DataM[Months]),DataM[Sales],SUM,,0)
Thanks
| Managing Partner @ Green Systems Technology Solutions| Director @ HTF Staffing Growth Strategy and Delivery Management for Business Expansion and Success.
1 周Rahim Zulfiqar Ali Would?you?mind?sharing?your?Excel?file?for?practice?
Principal Consultant & Owner en MSV Group
1 周Dear Rahim Zulfiqar Ali, it's possible you share your excel file to practice?
Transformación Digital en Finanzas | Ingeniero Civil Industrial | Control de Gestión y Reportería Financiera | Líder en Proyectos Estratégicos de Innovación
1 周Excellent
Founder & CEO Excel Basement, Excel, POWER BI, Python Trainer & Consultant, MBA (MIS), Microsoft Certified Trainer MCT, Emerging Data Scientist | 194K Followers
1 周GroupBy to Summarize Sales via Months & Sorted Chronological based on Fiscal Months Calendar in Microsoft #Excel 365 =SORTBY(GROUPBY(Data[Months],Data[Sales],SUM,,0),MATCH(CHOOSECOLS(GROUPBY(Data[Months],Data[Sales],SUM,,0),1),Fiscal_Months,0)) Top 3 Months & Sales Sorted! =SORT(FILTER(B6#,C6:C17>=LARGE(C6:C17,3)),2,-1) GroupBy to Summarize Sales via Month & Sorted Chronological based on JAN-DEC Calendar in Microsoft Excel 365 =GROUPBY(--(1&DataM[Months]),DataM[Sales],SUM,,0)