CrossTab Help

[Aaron]

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

[Aaron]

bump
 anyone have any idea why the crosstab is behaving this way?

[Aaron]

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.