If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Max Total of "Max" in reports
Please help!
Here's the situation. I receive a high level spreadsheet report with estimated totals by category. I then receive a spreadsheet by catagory showing individual results for each item within that category. I then run a query that combines the high level information to the individual category information and report of this, so each individual line will also contain the estimated total value of that category. In the report there are three columns: Category Name Estimated Total Total received For the total received i do a count function on the individual item level in the combine query. For the estimated total i do a max for the estimated total column in the combine query. This works for each category's "estimated total", but once i get to the subtotal and total sections for estimated total i run into problems. If i use a max function for estimated total i receive only the highest value for all the categories as my total. If I use a sum i receive back a sum by each individual line of the estimated totals, a huge number. Is there a way to report on results in a way that will take each category's estimated total only once and add them togetherinto a grand total? thanks! |
#2
|
|||
|
|||
I ended up creating a subtotal and total column in the high level report and
maxed this value to get the subtotals and totals. This allows me to keep the individual level detail for reporting within the same high level report. Not the prettest solution but it worked. Please let me know if there is a better way. "buddhapenguin" wrote: Please help! Here's the situation. I receive a high level spreadsheet report with estimated totals by category. I then receive a spreadsheet by catagory showing individual results for each item within that category. I then run a query that combines the high level information to the individual category information and report of this, so each individual line will also contain the estimated total value of that category. In the report there are three columns: Category Name Estimated Total Total received For the total received i do a count function on the individual item level in the combine query. For the estimated total i do a max for the estimated total column in the combine query. This works for each category's "estimated total", but once i get to the subtotal and total sections for estimated total i run into problems. If i use a max function for estimated total i receive only the highest value for all the categories as my total. If I use a sum i receive back a sum by each individual line of the estimated totals, a huge number. Is there a way to report on results in a way that will take each category's estimated total only once and add them togetherinto a grand total? thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Wrong Total Page Count On Reports? | Ellswrth | Setting Up & Running Reports | 0 | May 9th, 2005 04:51 PM |
Grand Total Problem | PW11111 | Running & Setting Up Queries | 2 | March 11th, 2005 05:44 PM |
Total hours from Table into Report | HeatherLou1974 | General Discussion | 3 | March 7th, 2005 08:04 PM |
incorrect sums in report using 2 tables | jkendrick75 | Setting Up & Running Reports | 22 | December 13th, 2004 02:19 PM |
Need help w/ reports | Tom | Setting Up & Running Reports | 0 | June 25th, 2004 05:59 PM |