How to select data last update (Expression)?

[panwipa2528]

If I have data as excel (attach file)

I need 2 results as below

1. Count member uniq by status

Status	Count Member Uniq (Last Quarter)
A	3
B	1
C	2

2.summary sale by member but show last status (Q4)

Member_Code	Status (Q4)	Sum Sale (Q1-Q4)
100001	A	970
100002	A	1,044
100003	C	1,628
100004	C	897
100005	B	829
100006	A	1,304

[Anil_Babu_Samineni]

First one may be using this?

Dimension is Status

Expression

Aggr(Count({<Quarter = {$(=MaxString(Quarter))}>} Member_Code), Status)

May be for second one like below

Dimension is Member_Code

And expressions are

1) FirstSortedValue({<Quarter = {$(=MaxString(Quarter))}>} Status, -Sale)

2) Sum(Aggr(Sum(Sale), Member_Code))

[Anil_Babu_Samineni · Accepted solution]

PFA