I need to limit the number of rows in a table I am working on. My table looks like this:
Date | Count 1 | Count 2 | Count 3 |
---|
2017-12-06 | 14 | 27 | 16 |
2017-12-05 | 2 | 22 | 13 |
2017-12-04 | 19 | 19 | 11 |
Using a limitation on my dimension does not appear to work, as dimension limitations use a measure; I simply want the last 10 days to show up regardless of the values of the counts. I have read that Rank() might achieve what I am going for but I am not sure how it would work.