GroupBy Function to Summarize Sales & Sort Chronological based on Fiscal Months Calendar in Excel 365
Rahim Zulfiqar Ali
Founder & CEO Excel Basement, MS Excel, POWER BI, Python Trainer & Consultant, MBA (MIS), MCT, MSOM, ReSkills Coach, Emerging Data Scientist
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
3 天前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
3 天前Excellent
Founder & CEO Excel Basement, MS Excel, POWER BI, Python Trainer & Consultant, MBA (MIS), MCT, MSOM, ReSkills Coach, Emerging Data Scientist
3 天前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)