I have a rather simple form with date/time field, two drop downs and multiple text field.

I want to create a pivot chart with the date/rime field and the drop downs, however I only get the date/time field in list of options?