4 Replies Latest reply on Mar 3, 2016 10:26 AM by Tim Powers

# Filter a range of data (not Top/Bottom N)

Hi,

Would someone be able to help with creating a filtering system that allows me to choose the 1) the row number and 2) input an integer value representing the number of rows to display?

I'd like to be able to display, from a source with 1,000 records or so, the 20-30 records. So I'd like to be able to input into one filter, row '20', and in another one the number '10' so that records 20-30 are displayed,

I've been trying to create something that calculates from INDEX() but am having difficulty getting this right.

Any help is appreciated.

Thanks.

• ###### 1. Re: Filter a range of data (not Top/Bottom N)

Tim,

What's the significance of the row number? For the scenario you described with 1000 records, how should each row be numbered, descending 1-1000 based on a measure?

Ken

1 of 1 people found this helpful
• ###### 2. Re: Filter a range of data (not Top/Bottom N)

Hi there Kenneth,

Thanks for the response.

I meant in terms of the record's index, so if the data for this view happens to be descending/ascending, then the index number in that regard (descending specifically), yes based on a measure list.

• ###### 3. Re: Filter a range of data (not Top/Bottom N)

Tim,

I've attached a workbook using the INDEX function to achieve what I think is your desired result. I created two parameters to control the user input part of the problem as well as a calculated field to filter the view to the user input starting row/# of rows.

The key to making this work is fixing the sort on the index function so that it doesn't reassign the index values based on the field members in the view. Have a look and let me know if this is what your after.

Ken

1 of 1 people found this helpful
• ###### 4. Re: Filter a range of data (not Top/Bottom N)

Hi Ken,

Thanks for your help; this looks to be exactly what I want to do. I'll go ahead and throw it into my workbook - thanks again for helping me out with this!

Tim