Forum Discussion

Copper Contributor

Mar 15, 2026

Solved

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

There are three data columns in the shared Excel file at the link below. Membership ID formatted as text Num (billing id) formatted as text FiscalYear formatted as numeric The pivot table value...

excel

IlirU
Mar 17, 2026
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

IlirU

Iron Contributor

Mar 17, 2026

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