cross tab reports cloumns adding

[sureshkt]

hi
i have a issue with my current crosstab report the reports look like

                               year                                                          Y1
                               q1                     T1    q2      T2       q3    q4
                               jan     feb    mar
                               c   a   c  a  c  a

employee1                 1   3   1  4  5  6    7

employee2                  2   3  1  5  5  7    8


T1=sum of all ''c''  for each quarter
Y1= T1+T2+T3+T4


please let know how find the T1.... & Y1
where 'c' is calculated col ,'a' is average
early reply is appreciated

thanks

[Rajaggopal]

First off, set the default measure of the crosstab to data item c. After that click on month column in the cross tab and click the aggregate button on the toolbar and select Total. This should give you column T1...T4, the total of column 'c' for each quarter. To get Y1... Yn repeat the same procedure by clicking the Quarter column in your crosstab. The below are the exact steps to be followed.

1. Click on any crosstab cell, select the ancestor button on the properties pane and select Crosstab.
2. Now select the Default Measure property and choose column c as the default measure.
3. Click Month column and click aggregate button on toolbar and select Total.
4. Click Quarter column and click aggregate button on toolbar and select Total.

Here is a screenshot of a sample output, which i believe matches your requirement.



You can rename the totals column by specifying Report expression for Source type property and providing appropriate Report Expressions. The report expression for Quarter total column is 'Total Deviation for '+[Query1].[Quarter]

[bonniehsueh]

These were good detailed instructions Rajaggopal!

[Rajaggopal]

Thanks Buddy :)