Max of Fiscal Year in pivot table Value section is not working

k_straz​,

For me everything works as it should.

In the screenshot above I have shown the solution using the formula and the one using the Pivot Table.

Through the Pivot Table you will need to go to the Value Field Settings window and under the Summarize Values ​​By tab select the Max option. I have applied the Pivot Table to cell H1.

If you want the solution using the formula then I have used the following formula in cell E1:

=VSTACK({"Membership ID","Max of FiscalYear"}, GROUPBY(B2:.B50, C2:.C50, MAX,, 1))

Hope this helps.

IlirU