Pivot Table how to show latest value in the period instead of sum total

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
672
I have a table like this

Country, headcount, Month
==================
US, 23, May2019
US, 24, Jun2019
UK, 27, May 2019
UK, 27, Jun 2019

Now pivot-table of Country as row and Month as Column, the Q2 column is showing 47 (23+24) for US.
Is there a way the Q2 column be the latest value in the Quarter, ie 24 instead ?

Thanks
 

Forum statistics

Threads
1,078,211
Messages
5,338,888
Members
399,265
Latest member
aj17x55

Some videos you may like

This Week's Hot Topics

Top