Crosstab Formating.....

[k2]

Hi,

I am working in crosstab report in the column am having one dataitem, which has 15 values and i need to display those values by adding every five values and display the subtotal and the final total as well. Could some one help me out, how to achieve this in Report studio version 8.3. Thanks

                          Col 1   Col 2  Col 3   
   --------------------------------------------------            
   Value 1            
   Value 2            
   Value 3            
   Value 4            
   Value 5            
   Value 6            
   Total of Values from (1 to 6)            
   Value 6            
   Value 7            
   Value 8            
   Value 9            
   Total of Values from (6 to 9)            

[dumbell]

This is my theory, try it if it works.

Make necessary queries
Q1-first 6 of dataitem with a filter
Q2...
Q3...
drop them in rows and try total as aggregate. It will give subtotals and totals.

Good Luck

Dumbbell

[dumbell]

Forgot to mention one of the step before drag and drop, join the Q1,Q2.. with some dummy.