Could you help me with requirement, I really appreciate your help.
I have a requirement to increment yearly by 5 years then increment by 5 years in column shelf. Please see below example.
You could try a calculated field like the following (assuming your Year field is an integer):
if [Year]<=2021 then str([Year])
elseif [Year]<=2026 then "2021-2026"
elseif [Year]<=2031 then "2027-2031"
Does that help?
Retrieving data ...