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|
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.