Hello -
Say I have the following data in QV:
| Sales | Year | Country |
| 90,000 | 2009 | Country A |
| 40,000 | 2009 | Country B |
| 100,000 | 2009 | Country C |
| 60,000 | 2010 | Country A |
| 40,000 | 2010 | Country B |
| 90,000 | 2010 | Country C |
| 30,000 | 2011 | Country A |
| 80,000 | 2011 | Country B |
| 10,000 | 2011 | Country C |
| 50,000 | 2012 | Country A |
| 70,000 | 2012 | Country B |
| 10,000 | 2012 | Country C |
I created a chart/table that shows sales value by year (aggregated by country). I would like to create a slider/filter that allows me to chose parameters based on total sales, not individual. For example, the 2009 total sales from above is 230,000 (90,000 + 40,000 + 100,000). I would like to have the ability to choose a filter value between 150,000 to 300,000 and have the 2009 total display. When I add a slider however, the max value that shows up on the slider is 100,000 (since that's the max sales line item in the data set above). How would I create a slider that would allow the user to filter values based on aggregated yearly sales? (example attached)
