This is a migrated thread and some comments may be shown as answers.

CrossTab Help

2 Answers 83 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Aaron asked on 05 Sep 2012, 05:55 PM

Hello,

I am having some issues with the crosstab. The issue seems to be in the way it is displaying the data. It is showing one row per record found which is not correct. First, here is the data I am referencing:

ID,RowIndex,ColIdx,Name,Amount,Category

3482,1,1,Tera,100,Fung

3482,1,2,Rid,200,Fung

3482,1,3,Man,100,Fung

3482,1,4,Vy,1,Inse

3482,1,6,Am,2,Inse

3482,1,8,Mon,55,Inse

3482,2,1,Tera,200,Fung

3482,2,3,Man,50,Fung

3482,2,5,WP,88,Inse

3482,2,9,Fu,66,Inse

3482,3,1,Tera,300,Fung

3482,3,2,Rid,100,Fung

3482,3,3,Man,80,Fung

3482,3,5,WP,5,Inse

3482,3,7,As,4,Inse

3482,3,8,Mon,5,Inse

3482,3,9,Fu,2,Inse

3482,4,4,Vy,45,Inse

3482,4,6,Am,66,Inse

3482,5,4,Vy,78,Inse

3482,5,6,Am,8888,Inse

3482,5,8,Mon,9999999,Inse

3482,5,9,Fu,87,Inse

I am setting up the crosstab as follows:
Row Group is: RowIndex
Detail Values: Sum(Amount)
Column Groups: Name

What am i doing wrong here or how do i need to format my data to have it output correctly.

I hope I have provided enough information here and if not please let me know.

Thanks

CrossTab Help

2 Answers, 1 is accepted