G
gmacklis
I've created a report that uses conditional formatting to highlight certain
individuals who are more than 2 StDev above the average. This works great
when I run the report for everyone or limit the report to only one location
at a time. However I want to be able to run one report for everyone and
group them by location.
I added a group header and footer to run the report for everyone but group
them by location. This, too, works great. However, the conditional
formatting stopped working correctly. My report is still basing its
formatting decisions on everyone's data and not just the grouped data for
each location.
Can this be fixed?
individuals who are more than 2 StDev above the average. This works great
when I run the report for everyone or limit the report to only one location
at a time. However I want to be able to run one report for everyone and
group them by location.
I added a group header and footer to run the report for everyone but group
them by location. This, too, works great. However, the conditional
formatting stopped working correctly. My report is still basing its
formatting decisions on everyone's data and not just the grouped data for
each location.
Can this be fixed?