Skip to Content
0
Former Member
Aug 19, 2011 at 11:43 AM

Break Crosstab columns

208 Views

Hi All

I am looking for a way to break a crosstab columns and let it grow vertically rather than horizontally.

For an example:

1. Create a crosstab with a field "Country" in the Columns section, a field "Year" in Rows section and a field "Shop_Name" in Summerized fields section.

2. Suppress the subtotals and the grand totals.

3. This will create a cross tab as below:

USA Canada Germany

2001 2 7 6

2002 3 8 6

2003 4 9 6

2004 5 10 6

2005 6 11 6

4. We are in need to break this cross tab in order to show it as below, if it crosses N-number of columns(In this case N=1):

USA

2001 2

2002 3

2003 4

2004 5

2005 6

Canada

2001 7

2002 8

2003 9

2004 10

2005 11

Germany

2001 6

2002 6

2003 6

2004 6

2005 6

I know of a way to break the cross tab in horizontally and looking for a way to break it vertically (after N-number of columns).

Thank you for the help in advance.

Regards

Nikhil Sabnis