Not applicable
2017-08-29
11:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to Generate YTD Metrics with pivot table
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.
281 Views
1 Reply
techvarun
Specialist II
2017-08-29
11:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try the below code as expression:
rangesum( above( Count(MemberId),0,2) )
249 Views