Greetings all I am new to focus, after reviewing documentation and the forums i have a question i would like help with if you guys have a chance. I am creating a multilayered report based on two categories of data accts. The report works on a rolling 12 month and a ytd format the below is the layout.. I can calculate each value separately i just dont know how to put them together
category 1
Data Acct p1 p2 p3 p4 p5 etc...... curytd priytd var
11111 10 5 3 5 4 ........ 30 10 20
11345 7 4 5 4 4 29 12 17
etc...............................
etc...............................
etc...............................
Total other 10 10 10 75 50 25
Total category 1 10 10 10 150 100 50
Category 2
same as category 1 just different accts


This is a rough rough version of what i am looking to create.

Thanks for your assistance

So you are sorting first by account category then by account with subtotals on category.
TABLE FILE ACCOUNTS
SUM P1 P2 P3 CURYTD PRIYTD VAR
BY CATEGORY
BY ACCOUNT
ON CATEGORY SUBTOTAL
END

Is this what you're looking for?

Darin, Sorry I was horribly vague .. Within Category 1 there are 6 sections.. to get from category 1 to 2 i will just use the report component for pdf's. My question is largely centered around category 1.
First their are ~30 data accts i am only looking for the top 5 by year to date variance.
those five are then displayed with the rolling 12 periods of data (section 1) next to that is their ytd data (section 2) Then i display all the remaining to a summed value for the same periods as (section 3) and that ytd info next to it as (section 4) then i display total category data per period as (Section 5) and YTD next to that as (Section 6)
acct P1 2 3 4 5 6 7 8 9 10 11 12| CURYTD PRIYTD Variance
1 |
2.............................(Section 1)| (Section 2)
3
4
5
Total other ................(section 3) | (Section 4)
TOTAL ...................(Section 5) | (Section 6)

If you think it is easier to do all together that is great for me.. I am doing each section separately now.. and wanted to compile and then do the same process for the second category and then use the Component detail mentioned in the post about combining components and preparing PDF reports.. I would enjoy yielding to everyones expertise here as i am quite impressed with most of the code solutions i see on here.. that and i tend to over complicate and over design at times..

thanks for the additional info. I have a report that basically does the same thing, sorting claims by accident category, then showing the highest five categories and summing all the rest. Looks something like this:
TABLE FILE CLAIMS
SUM CLMCNT NOPRINT
RANKED BY HIGHEST TOTAL CLMCNT
BY ACC_CD
ON TABLE HOLD AS RANKCNT
END
-RUN
DEFINE FILE RANKCNT
NACC_CD=IF E01 LE 5 THEN E03 ELSE 'ALL OTHERS';
END
TABLE FILE RANKCNT
SUM CLMCNT AS ''
BY NACC_CD AS ''
END

E01 here is the column ranking, E05 is the accident code
Then you can still use subtotals, etc.
you probably want to compute the variance anew rather than pull the value from the hold file.
Sections one and two are just fields that you have defined/computed. (detail for highest 5) Sections three and four are the same fields (all others summed). Sections five and six are just subtotals/recomputes

Darin

Thanks a ton.. the code works perfect