Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Week | Count(Distinct id) | Expected output | |
WK1 | 10 | 10 | |
WK2 | 15 | 25 | |
WK3 | 10 | 35 | |
WK4 | 50 | 85 | |
WK5 | 30 | 115 | |
WK6 | 20 | 135 | |
WK7 | 10 | 145 | |
WK8 | 60 | 205 | |
WK9 | 20 | 225 | |
WK10 | 15 | 240 |
RangeSum(Above(Sum(Count), 0, RowNo()))
What if I want to use final count in KPI