We have set up the below 4 fields as "conditional" drop down fields.

 

Example below: We have a total of 8 products listed under the "Product" field. If agent picks say Product 1, then the field name populates as Case Classification(Product 1) and has 4 case classifications to choose from. Say, the agent picks Class 1, then field Case Sub-Class (Product 1-Class 1) field gets displayed with a number of options to choose from. Say, the agent picks SubClass 4 value; then field Case Sub-class Category (Product 1-SubClass 4) gets displayed with options Sub-class Category 1 to Sub-class Category 10 to choose from.

 

This is the cycle for all Products 1 to 8. Hope this helps in your understanding.

 

We would like to run a report to show a descending order of our top trends with the rows being the third conditional field which comes after the Case classification field mentioned herein.

 

 

Product	Case Classification	Case Sub-Class	Case Sub-class Category
Product 1	Class 1	SubClass 1
		SubClass 2
		SubClass 3
		SubClass 4	Sub-class Category 1
			Sub-class Category 2
			Sub-class Category 3
			Sub-class Category 4
			Sub-class Category 5
			Sub-class Category 6
			Sub-class Category 7
			Sub-class Category 8
			Sub-class Category 9
			Sub-class Category 10
		SubClass 5	Sub-class Category 11
			Sub-class Category 12
			Sub-class Category 13
			Sub-class Category 14
		SubClass 6	Sub-class Category 15
			Sub-class Category 16
			Sub-class Category 17
			Sub-class Category 18
			Sub-class Category 19
			Sub-class Category 20
	Class 2	SubClass 7	Sub-class Category 21
			Sub-class Category 22
		SubClass 8	Sub-class Category 23
			Sub-class Category 24
		SubClass 9	Sub-class Category 25
			Sub-class Category 26
			Sub-class Category 27
	Class 3	SubClass 24
		SubClass 25
		SubClass 26
		SubClass 27
		SubClass 28