sudhakarpatnapu
Technical User
I have cross tab table in the following format and use the option summarize horizontally to get sub columns(module1,module2) in every month
Day Jan Feb Mar Apr May...........Dec
module1 module2 module1 module2 module1 module2
1 2 3 3 3 3 3
2 3 4 3 2 2 4
3 2 2 2 3 4 3
.
.
.
31 1 1 1 1 1 1
Sub-Total 8 10 9 9 10 11 (here Sub-Total is sum of each module for each month)
Cumulative ST 8 10 17 19 27 30 (here Cumulative ST is sum of jan(module1), jan(module1)+feb(module1),jan(module1)+feb(module1)+mar(module1),....same for module2
Total 18 18 21 (here Total is sum of both modules in each month)
Cumulative T 18 36 57 (here Cumulative T is sum of sum(Total) )
I am not using any formulae as total is calculated by crosstab.
database fields used in the cross tab expert are, for rows command.days(1,2,3...31), for column command.month(jan,feb, mar,....Dec), for column module1(command.TOTModule1), for column module2(command.TOTModule2),
so Sub-Totals are sum(command.TOTModule1),sum(command.TOTModule2).
I need the cumulative ST, Total and Cumulative T rows in the bottom of cross tab..i refered below link
i am not able to add new row in crosstab becoz i choose the option summarize horizontally. please help me. any ideas?
Day Jan Feb Mar Apr May...........Dec
module1 module2 module1 module2 module1 module2
1 2 3 3 3 3 3
2 3 4 3 2 2 4
3 2 2 2 3 4 3
.
.
.
31 1 1 1 1 1 1
Sub-Total 8 10 9 9 10 11 (here Sub-Total is sum of each module for each month)
Cumulative ST 8 10 17 19 27 30 (here Cumulative ST is sum of jan(module1), jan(module1)+feb(module1),jan(module1)+feb(module1)+mar(module1),....same for module2
Total 18 18 21 (here Total is sum of both modules in each month)
Cumulative T 18 36 57 (here Cumulative T is sum of sum(Total) )
I am not using any formulae as total is calculated by crosstab.
database fields used in the cross tab expert are, for rows command.days(1,2,3...31), for column command.month(jan,feb, mar,....Dec), for column module1(command.TOTModule1), for column module2(command.TOTModule2),
so Sub-Totals are sum(command.TOTModule1),sum(command.TOTModule2).
I need the cumulative ST, Total and Cumulative T rows in the bottom of cross tab..i refered below link
i am not able to add new row in crosstab becoz i choose the option summarize horizontally. please help me. any ideas?