Creating a layout using checkbox data
I am trying to create a layout where the information in a field that has checkboxes can be separated in to different columns.
For example, I have three fields with four check boxes labelled 1-4. I want to create a layout where I can columnate each separate check box number into four columns 1-4 and then have the number of records where each checkbox is ticked subtotalled down the bottom.
Eg. I have three records with a field for colour (drop box) and a field for shape (check box: round, square, oval)
How can I design a layout that shows in columns that for the colour red I have four round, 8 square and 2 oval?