Filter. Min value or/and all except certain values

[#1]

Good day,

I need help with using filters. In my case, I have a chart with X-axis Amount and Y-axis Price. I sorted Amount by Price. But now, I want to filter my data by:

1) showing the only amount of minimum price for each company separately. For example, it would be 8/12 for Company B, 10/22 for Company A and 20/63 Company C.

2) ability to choose certain values or all values except certain. For example, display each company's first 2 lowest price amounts (Company B 8/12 and 10/36; Company A 10/22 and 15/30; Company C 20/63).

Message was edited by: Vidmat Vidmat

[#2]

swuehl , could you explain to me how to create a slider object to set a variable to 1, 2, 3, please?

[swuehl · Accepted solution]

This is your original bar chart:

I created a variable vTest and a slider object:

And adding the expression to your chart returned

[#4]

swuehl‌, thanks. It works.