Hi
I have data from April 2019 to Mar 2020.
When i put the pivot table and put the date as group in the first it is coming as Jan Month in the first row. But i want April Month to come in the first row.
Because our Quarter is (April to March).
Kindly guide how to do in Pivot Table grouping.
Attaching the sample sheet for the reference.
Regards
Shahul
I have data from April 2019 to Mar 2020.
When i put the pivot table and put the date as group in the first it is coming as Jan Month in the first row. But i want April Month to come in the first row.
Because our Quarter is (April to March).
Kindly guide how to do in Pivot Table grouping.
Attaching the sample sheet for the reference.
Regards
Shahul