Report with detail for certain items and then summary for remainder

  • Thread starter Thread starter Rich Mogy
  • Start date Start date
R

Rich Mogy

Hi,
I have a report that shows detail for items with sales over $500K. I then
want to print
Widgets 100,000,000
Gadgets 75,000,000

Total 175,000,000

Under 500 K 275,000

Total Sales 175,275,000


I can figure out the first part, but the Under 500K and total is driving me
crazy. Any suggestions would be appreciated.

Thanks

Rich
 
Put a textbox in your report footer for total as =Sum([YourField])

Set the Running Sum property to Over All or Group as you need it.
 
I don't understand. There may be 10 products that are summarized as under
500K. (each 27.5K) How does your solution get the 275K.
KARL DEWEY said:
Put a textbox in your report footer for total as =Sum([YourField])

Set the Running Sum property to Over All or Group as you need it.

Rich Mogy said:
Hi,
I have a report that shows detail for items with sales over $500K. I
then
want to print
Widgets 100,000,000
Gadgets 75,000,000

Total 175,000,000

Under 500 K 275,000

Total Sales 175,275,000


I can figure out the first part, but the Under 500K and total is driving
me
crazy. Any suggestions would be appreciated.

Thanks

Rich
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary report question 4
dynamic summary report 11
Report for Max, Ave & Detail Record for Highest Sale Price by Cate 1
Pivot Tables: Don't show data for detail, but still show subtotals 3
Summary USA sales 1
Multiple Listbox selectin and query criteria 11
Summary Report - Ability to Drill Down a line Item Detail 4
Group last line of details and report footer 0

Back
Top