J
Josh
Hello,
I am currently having a problem in a report that I created. I have the data
grouped by "Line" and then the resulting data contains "Associate ID" and
"number of hours worked in this area".
The problem is that when I do a running sum over the total to count the
unique values, the report properly counts only the unique values within each
grouping, but then if that employee worked in two different areas, they are
counted a second time. I am not sure if there is a way to solve this
problem, since it makes the report useless. I don't want to have to re-group
, since it makes the report useless.
Is there any other way to do this aside from using a running sum over all?
Thanks in advance.
I am currently having a problem in a report that I created. I have the data
grouped by "Line" and then the resulting data contains "Associate ID" and
"number of hours worked in this area".
The problem is that when I do a running sum over the total to count the
unique values, the report properly counts only the unique values within each
grouping, but then if that employee worked in two different areas, they are
counted a second time. I am not sure if there is a way to solve this
problem, since it makes the report useless. I don't want to have to re-group
, since it makes the report useless.
Is there any other way to do this aside from using a running sum over all?
Thanks in advance.