3 Replies Latest reply on May 22, 2012 4:48 AM by Jonathan Drummey

    sorting with pages shelf

    Danielle Farrie

      I have a sheet that has test score data by school for multiple grade levels in bar chart format. I would like to use the pages shelf for the grades, so users can easily click through to see performance at every grade level (I think it is too busy to have a sheet on the dashboard for each grade).  I also need the bar chart sorted by the test scores. If i use the pages shelf, the sort is using the aggregate test score for all grades while i want it to sort only by the test score that is displayed on that page. And the bar chart displays schools even if they have null values (i.e. grade 4 test scores will still show the high schools on the axis). Is it possible to change this or is this not how the pages shelf is designed to be used?