Default Quarter Selection

[MMK]

Hi Team,

Thanks for your support in advance.

In a table i am having Country, Period ID, Year, Month, Sales. I want to show Sales of the country over Periods.

Like Current Period (vs) Last Year Last Quarter. Example Present i want show Q2-2024 vs Q4-2023 in the next Quarter in table i want to show Q3-2024 vs Q4-2023..... Like that in Q1-2025 vs Q4-2023 in future I want to show. What is optimum way to get this.

From source, I am getting Period ID randomly as shown below.

Period ID	Year	Month
31	2022	DEC
38	2023	MAR
45	2023	JUN
54	2023	SEP
59	2023	DEC
60	2024	MAR
65	2024	JUN

In a pivot table i want to show, Country level sales for Current Quarter vs Last year Last Quarter.

Country

Q2-2024

Q4-2023

In future i want same comparison 

Country

Q3-2024

Q4-2023

[upllop]

I have created a "Quarter" that lists all quarters, but changes the value for the current quarter, to "Current Quarter". I sorted it so it was always at the top, and made the slicer single select and selected that item as the default selection before publishing.

Would that work?