For each quarter, show the value of the third month (last month of the quarter)

[Ax]

Hi!

I have a table where I would like to show one 'Price' value for each quarter.

For each quarter, the table should show the third  / last months value of the quarter.

For example for Q1 it should show March's value.

I found somewhat similar question in another thread where the following was proposed, but it was not working for me.

=sum(
{<
YearMonth = {'$(=MaxString(YearMonth))'}
>}
Price)

Thank you!

[Ax]

I have a table where I would like to show one 'Price' value for each quarter.

For each quarter, the table should show the third  / last months value of the quarter.

For example for Q1 it should show March's value.

I found somewhat similar question in another thread where the following was proposed, but it was not working for me.

=sum(
{<
YearMonth = {'$(=MaxString(YearMonth))'}
>}
Price)

Thank you!

[PrashantSangle]

Try quarterend() this will quarterend of every quarter.

Can your share sample data that will help us to build the exact expression which you are looking for.

Regards,

Prashant Sangle

[Ax]

Unfortunately, this does not seem to work. Thanks for your response.

It counted the sum of the whole quarter.

Starting data

Month	Price
January	1000
February	1100
March	1200
April	1300
May	1400
June	1500
July	1600
August	1700
September	1800
October	1900
November	2000
December	2100

Desired result

Quarter	Q2	Q3	Q4	Q5
Price	1200	1500	1800	2100

[Or]

Assuming the monthnames are actually a date and can be sorted, you could try using FirstSortedValue(Price,-Month). If the month names are textual, you'll need to get them set up as numeric values first since "December" does not inherently come after "October".