B
buddhapenguin
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!
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!