Forum Discussion

Lena_K's avatar
Lena_K
Frequent Visitor
8 years ago
Solved

Filter / Slice by column

I suspect the answer is 'its not possible' to this question, but I am hoping there is a trick I'm missing

 

I have a data set where each row represents an individual - the first group of columns are characteristics about that individual, there is then a group of columns with different measures in.

 

I have set a report up which shows the measures split by the characteristics of the inidividual.

 

In the example shown for instance the charts use KS2_ELIGRWM as the value and KS2_RWMEXP as the legend / detail - the various characteristic columns are used for the axis.

 

The only way I can see to create the same set of charts for the other 2 measures shown (KS2_ELIGREADLA and KS2_ELIGMATLA) would be to duplicate the pages and change the measures manually - however, ideally I would like to be able to put a selector in so that they can be selected on the same page - is there a way of doing this?

 

 

2 Replies

    • Lena_K's avatar
      Lena_K
      Frequent Visitor

      Fantastic - worked a treat - thank you!