Forum

Grouping of Quarter...
 
Notifications
Clear all

Grouping of Quarters not following Calendar Years

2 Posts
2 Users
0 Reactions
83 Views
(@noormos)
Posts: 14
Eminent Member
Topic starter
 

Hi,

May I know how to group row labels in Pivot Table according to quarters that are not following calendar year?

Example:

Calendar Year:

Quarter 1: Jan, Feb, Mar

Financial Year:

Quarter 1: Jul, Aug, Sep

Thanks.Confused

 
Posted : 28/09/2018 7:39 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Safirah,

This post explains how to convert dates into fiscal periods. And this post shows you how group dates into fiscal years for Slicers, but you could just as easily apply it to quarters.

Mynda

 
Posted : 28/09/2018 8:16 am
Share: