I'm using conditional fields in all of my forms which works nicely but i'm running into a problem while reporting. Structure is:
Example if I have a form call Entertainment, with fields Art, Music, and Film. A user selects Music and MusicSubField appears. User selects Rock and submits the ticket. On the back end ArtSubField and FilmSubfield are NULL.
Essentially, I'd like to aggregate ticket counts based on subfield.