Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am finding a way to check whether a given date is fall within the financial year period. After that, I want to count on the ID of the Date where the Date is falling inside the financial year range. The FY will be my dimension in the report.
Financial Year 2012: July2011 to Jun2012
Financial Year 2013: July2012 to Jun2013
Raw Data:
ID | Date |
001 | 14/02/2012 |
002 | 20/08/2012 |
003 | 31/03/2012 |
004 | 14/06/2012 |
005 | 22/07/2012 |
006 | 31/05/2012 |
After sorting:
Dimension FY | Date |
FY2012 | 14/02/2012 |
31/03/2012 | |
31/05/2012 | |
14/06/2012 | |
FY2013 | 22/07/2012 |
20/08/2012 |
Result:
Dimension FY | Count of ID |
FY2012 | 4 |
FY2013 | 2 |
Thanks for your help and guides!
Regards,
SC
Hi,
Please find attached file for solution. Hope attached file helps you.
Regards,
Jagan.