help for building subtotals with different fields

[karibai]

Hi All,
i shall write a report, which has the following design.
I need subtotals after field 2 for field 4 and field 2. If You don't understand my (bad) english, please, look at the following example:


Field 1 Field 2 Field 3 Field 4 Count 5 days 10 days
SO B FKA 1 5141 47,50% 66,70%
FKA 2 6372 40,70% 58,10%
PKA 1 69391 51,40% 77,50%
PKA 2 30308 41,60% 64,70%
VTA 1 704 28,70% 43,30%
VTA 2 2130 32,40% 48,80%
----------------------------------------------------------
B 1 75236 51,00% 76,40%
B 2 38810 40,90% 62,80%
----------------------------------------------------------
B 114046 47,50% 71,80%
==========================================================
etc. ...
....
----------------------------------------------------------
SO 1 189986 28,60% 43,20%
2 40940 1,70% 2,50%
----------------------------------------------------------
230926 23,90% 36,00%
----------------------------------------------------------
SW F FKA 1 7107 47,00% 67,20%
FKA 2 10504 41,30% 59,70%
PKA 1 38749 75,10% 88,70%
PKA 2 26349 61,10% 77,70%
VTA 1 701 40,10% 62,50%
VTA 2 1216 39,90% 67,00%
F 1 46557 70,20% 85,00%
F 2 38069 54,90% 72,40%
F 84626 63,40% 79,40%

etc
TOTAL xxx xxx xxx

Is there any possibility, to realize this report in this way?

Thanx
Karin

 

[bcbasslet]

yes, using FML (the Financial Modelling Language component of Focus..it's part of the core product)
You seem to want to subtotal B for FKA=1 and then again for FKA=2, and then again for all FKA of that B.
Subtotal isn't the right word, you want RECOMPUTE's because of the percentages.
this kind of thing is perfect for FML. Just read about it in you manuals and you'l love it.
sometimes its called EML (for extended matrix language)
It basically pulls your final report data into a matrix, and then lets you operate on that matrix with Excel-like commands,(row and col references) all in the same fex. way cool.

-SUSANNAH