Yes this possible based on "Grouping";) Find approach in attached workbook version 10.3 located in the original thread
grouping_nalmai_10.3.twbx 40.0 KB
Thank you for your quick answer.
But I still have an issue, I have so many records and dates and can not do it manually, it will take a long time.
Is there any simpler solution?
Thank you again,
1 of 1 people found this helpful
IF YEAR([Date]) = 2015 then
ELSEIF YEAR([Date]) = 2016 or
(YEAR([Date]) = 2017 and MONTH([Date]) <= 6) then
ELSEIF YEAR([Date]) = 2017 and MONTH([Date]) > 6 then