GroupBy Function to Summarize Sales & Sort Chronological based on Fiscal Months Calendar in Excel 365

GroupBy Function to Summarize Sales & Sort Chronological based on Fiscal Months Calendar in Excel 365

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

TAHIR ZAFAR

| 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?

回复
Andrés Vargas de la Piedra

Principal Consultant & Owner en MSV Group

3 天前

Dear Rahim Zulfiqar Ali, it's possible you share your excel file to practice?

Mauricio Ba?arez Veloso

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

Rahim Zulfiqar Ali

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)

回复

要查看或添加评论,请登录

Rahim Zulfiqar Ali的更多文章