Creat three different charts (not cyclic) and use the buttons so that the 'by customer' button restores the customer graph and minimizes the other two and so on for the other two buttons. In the button properties under 'Actions' click the 'Add' button and choose Layout then Minimize Object or Restore Object
To continue contributing options, you can use a variable as a calculated dimension like : $(vCycle)
and then create an action on the button like:
=if(vCycle='Department','Teacher', if(vCycle='Teacher', 'Student', 'Department'))
Please find attached.
Also, you can use a macro like:
But I wouldn't recommend a macro if there are non-macro solutions.
Hope this helps!
Cycle Button.qvw 153.8 K