report issue for display of values

[nfldbunker]

hi

i have a report which contains things such as institution, chart#, reg#,diagnosis type and LOS (length of stay). All totals and averages are correct.

This report needs to be modified to reflect only institution and LOS . i have cut out some of the other elements in the report and left with
institution and LOS but it shows the LOS for every chart number that is contained in the report. Is there a way to only show summarized value for LOS for each institution and not each individual row.

please let me know

bunker
   

[blom0344]

If the LOS is a proper aggregate it should only show 1 (aggregated value) for each dimension. There is one clear exception: it is possible to change the query setting to show non aggregated data, which will return individual rows regardless of individual aggregate settings. So, check the query settings!!