Vertical Table

[#1]

I am here again with another problem. I have this data in an Excel File:

Title 1	Title 2	Title 3	jun-13
Primary	1021080	5235500001	820724835
Primary	1021080	5235500006	654480574
Primary	1021080	5235500012	45696827
Secundary	1021080	5235500002	80371512
Secundary	1021080	5235500003	118080930
Secundary	1021080	5235500013	9463308
TAT	1021080	5235500007	222962791
TAT	1021080	5235500014	54330714
TAT	1021080	5235500015	12911312
Derivable	1021080	5235500008	189631760
Devolutions	1021080	5235500004	10313974

And I need to create a report with this structure and subtotals:

Title 1	Title 2	Title 3	jun-13
Primary	1021080	5235500001	820.724.835
Primary	1021080	5235500006	654.480.574
Primary	1021080	5235500012	45.696.827
Total Primary			1.520.902.236
Secundary	1021080	5235500002	80.371.512
Secundary	1021080	5235500003	118.080.930
Secundary	1021080	5235500013	9.463.308
Total Secundary			207.915.750
TAT	1021080	5235500007	222.962.791
TAT	1021080	5235500014	54.330.714
TAT	1021080	5235500015	12.911.312
Total TAT			290.204.817
Derivable	1021080	5235500008	189.631.760
Total Derivable			189.631.760
Devolutions	1021080	5235500004	10.313.974
Total Devolutions			10.313.974
TOTAL			2.218.968.537

Thanks.

[#2]

The resulting structure is not quite the same but you could try a pivot table and apply partial sums at Title1/Title2 level:

You could put a formula in "Label for Totals" above to apply custom labels.

In the above example Title1, Title2 and Title3 are dimensions, and column "Sum" is the expression sum([jun-13])

[#3]

Thanks Kai !!