12 Replies Latest reply on Jan 31, 2013 6:42 AM by Shawn Wallwork

# to take between the fifth and the tenth values

hi,

i have a table with a column "name" and a column "values".

I want to take between the fifth and the tenth values.

• ###### 1. Re: to take between the fifth and the tenth values

See attached.

• ###### 2. Re: to take between the fifth and the tenth values

thank you for your help, but i want to do this automaticaly...

you have a solution like this maybe?

thank you.

aym

• ###### 3. Re: to take between the fifth and the tenth values

What kind of "automatically" ? Can you explain a little more?

--Shawn

• ###### 4. Re: to take between the fifth and the tenth values

Hi Aym,

Shawn's solution is close to being automatic because it is using the Index table calculation which is essentially just giving a value of 1-X for each row. As long as your dimension is sorted the way you like, when the data is updated, the filter will only take the 5-10 rows.

-Tracy

• ###### 5. Re: to take between the fifth and the tenth values

Aym, what Tracy said. Also if you don't want to see the Index column just uncheck "Show Header".

--Shawn

• ###### 6. Re: to take between the fifth and the tenth values

hi tracy and shawn,

thanks a lot for your help, but i want a checkbox for 1-5; 6-10; 11-15.... and when i check 6-10 i have between the fifth and the tenth values...

it's possible to do this?

thank you.

• ###### 7. Re: to take between the fifth and the tenth values

See attached.

• ###### 8. Re: to take between the fifth and the tenth values

hi Shawn,

i have a last question about this. i want when i click on the arrow (in the dashboard) one action which do this

- 0-5 ->6-10 etc...

• ###### 9. Re: to take between the fifth and the tenth values

Aym, that's a whole different deal. I'm in the middle of 3 projects, so I won't be able to get to this right away. Joshua just did a sheet swapping post, so he might be able to send you in the right directions.

• ###### 10. Re: to take between the fifth and the tenth values

Aym,

I took a quick look at the workbook. I'm not sure if sheet swapping will the answer here.  But you can take a look at the thread Shawn referenced and see if it might work.  http://community.tableau.com/message/198746#198746

I'll try to come back to this and see what other options there might be.

Joshua

• ###### 11. Re: to take between the fifth and the tenth values

thank you for your answer, but it's not the same thing Joshua.

else, tell me Shawn it's possible to put the measure "plage" in global?

• ###### 12. Re: to take between the fifth and the tenth values

Sorry, I was moving too fast. If you are asking if Tableau has a way of creating a paging sort of button that will page through a parameter by repeatedly clicking, then the answer is no.

--Shawn