How to Generate YTD Metrics with pivot table

Wed, 30 Aug 2017 03:30:44 GMT

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.

Re: How to Generate YTD Metrics with pivot table

techvarun — Wed, 30 Aug 2017 03:51:02 GMT

try the below code as expression:

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