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

CrossTab Help

2 Answers 40 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Aaron
Top achievements
Rank 1
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

2 Answers, 1 is accepted

Sort by
0
Aaron
Top achievements
Rank 1
answered on 06 Sep 2012, 11:37 PM
bump
 anyone have any idea why the crosstab is behaving this way?
0
Aaron
Top achievements
Rank 1
answered on 10 Sep 2012, 01:09 PM
I am guessing this must be a bug.  I will submit a ticket since I have not heard anything and see if i can get a response that way.
Tags
General Discussions
Asked by
Aaron
Top achievements
Rank 1
Answers by
Aaron
Top achievements
Rank 1
Share this question
or