What occurs when you sort by Quarter after sorting on Year?

When you sort by Quarter after already sorting by Year, the analysis sorts first on Year and then on Quarter. This means that the Year sort will still play a crucial role in the overall sorting process, as it establishes the primary grouping of the data.

When the data is sorted by Year first, the entries for each year are grouped together. Then, by sorting by Quarter afterward, it imposes an additional layer of sorting within those yearly groups. As a result, you get a detailed ordering that respects both dimensions: first organizing the data chronologically by Year, and then distributing that data into quarters for any given year.

This layered approach ensures that the quarter sort does not remove or revert the Year sort; instead, it enhances the data structure, making it more meaningful and easier to read in a time-related analysis. The notion of reverting to a single column sort or removing any previous sorts simply does not apply in this context. The combined sorting provides a hierarchical view, which is especially important in time-series analysis and reporting.