Crosstabs: how to display 2 "flat" column groups (and not one inside the other) - pics included

[krasci]

Hi there. I have a crosstabs with 2 column groups, year and category. The default display is "hierarchizing" the groups, i.e. category 1 and all the years, then category 2 and all the years. I want them flat, i.e. all the years, then all the categories. See the example, easier to understand:

Current layout:

	Category 1				Category 2				Category 3				Total category
	2014	2015	2016	Total years	2014	2015	2016	Total years	2014	2015	2016	Total years
Topic 1
Topic 2
Topic 3
Topic 4
Topic 5
Total

Desired layout:

	2014	2015	2016	Total years	Category 1	Category 2	Category 3	Total category
Topic 1
Topic 2
Topic 3
Topic 4
Topic 5
Total

Thanks!

[kaushik_hel]

Hi,

You may visit here - https://www.helicaltech.com/blog/

Hope we can help you. For more details please contact me - kaushik@helicaltech.com

Thanks

 

[krasci]

@kaushik_hel I had a look at your blog but didn't find any answer to my question.