Hello Everyone
This is probably a simple fix, but been driving me absolutely crazy. I have a large data set that I extract the year field from a date using the formula =YEAR([@DATE]). Pretty simple. I than put my data into a pivot table.
My pivot table is out of numeric sequence and it makes me bonkers. How do I fix this so 2021, 2022, 2023 and 2024 are sequential?
This is probably a simple fix, but been driving me absolutely crazy. I have a large data set that I extract the year field from a date using the formula =YEAR([@DATE]). Pretty simple. I than put my data into a pivot table.
My pivot table is out of numeric sequence and it makes me bonkers. How do I fix this so 2021, 2022, 2023 and 2024 are sequential?