Notifications
Clear all
Excel Dashboards
2
Posts
2
Users
0
Reactions
83
Views
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.
Posted : 28/09/2018 7:39 am
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