How to Generate YTD Metrics with pivot table

[#1]

Hi All, I have the following table:

TheMonth DayDate MemberId

2017-01-01 2017-01-02 1

2017-02-01 2017-02-02 2

2017-03-01 2017-03-02 1

2017-03-01 2017-03-03 3

And I want to use one Pivot table to show the total Members:

TheMonth, Members(count(distinct MemberId))

2017-01-01, 1

2017-02-01, 2

2017-03-01, 3

How to Achieve it? Thanks.

[techvarun]

try the below code as expression:

rangesum( above( Count(MemberId),0,2) )