jackie1948
Programmer
How do I get a total on a total and then total on that total and they all have to be at different breaks in the report.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TOTAL ON SUBTOTALS
- Thread starter jackie1948
- Start date
- Status
Jackie,
When you define a calculation field you can specify for which field this calculation is link, for exemple a product report can show a Total for each product. After this you can create a second calculation field who's sum all total of product.
You can create a total, with calculation field, for each grouping field of your report.
Gilles.
When you define a calculation field you can specify for which field this calculation is link, for exemple a product report can show a Total for each product. After this you can create a second calculation field who's sum all total of product.
You can create a total, with calculation field, for each grouping field of your report.
Gilles.
Or simply set your groupings within your report, then click on the field you want subtotals for and click on the Sum icon (the Sigma symbol).
Impromptu will automatically generate the appropriate footers for each grouping and put the totals in those groupings. Just delete those you don't need.
Pain is stress leaving the body.
DoubleD![[bigcheeks]](/data/assets/smilies/bigcheeks.gif "[bigcheeks] [bigcheeks]")
Impromptu will automatically generate the appropriate footers for each grouping and put the totals in those groupings. Just delete those you don't need.
Pain is stress leaving the body.
DoubleD
- Status
Similar threads
- Locked
- Question
- Locked
- Question