Easy Office
LCI Learning

in Pivot table


27 January 2010 How to group dates by financial year in Pivot Table

30 January 2010 First of all sort the date column in Ascending or Descending format and then filter it and then group it by filtering in "greater than or equal to = 01/04/XX01" and "less than or equal to = 31/03/XX02". In this way you can arrange dates in group of financial year you want.

02 February 2010 it does not work




You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries




Answer Query