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.
