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