Cross-tab Crystal Reports, grouping by database field

Question

I currently have a cross tab in my report where I read all the products that I want to display. They are already grouped by the respective customer who is associated with them, however I want to add an additional group to distinguish between different types of products.

For example, I have:

CustomerName Total Product Code1 3 24 72 Product Code2 3 24 72 Product Code3 3 24 72 

However, I want to have;

 CustomerName Total Red Products Product Code1 3 24 72 Product Code2 3 24 72 Blue Products Product Code3 3 24 72 

I have a Group By identifier in my database, is it possible to populate this second group at the crossroads? And how do I do this? Thanks

Answer 1

Perhaps: in Cross Tab Expert, select 2 lines and set the grouping options.

Appearance will not be desirable, but you can rotate the text of the 1st column 90 ° if you wish.

 CustomerName Total Red Products Product Code1 3 24 72 Product Code2 3 24 72 Blue Products Product Code3 3 24 72