I am trying to do a calculation that is taking me "Employee Name" Subtotal Measure over Standard Hours but getting a nesting error. When I drag it to the same level as the report grand total, the calculation works but off the total report. How do I make it calculate correctly without an error? Any help would be greatly appreciated!
Error: The aggregate dataItem="Total(Employee Name)" referenced by valueSet="8" is not expected to nest measures'.
(http://i.imgur.com/jYfv7ml.png)
I removed all the totals and then added each calculation/total in one by one
1) I removed all the Totals and added in my Utilization Calculation – Ran the report and it works
2) Then I added the Totals line to subtotal all Brands at the Employee Level – Ran the report and it works
3) Last, I added a Grand total at the bottom and this is where it breaks with the error below
"The aggregate dataItem="Total(Employee Name)" referenced by valueSet="7" is not expected to nest measures'."
(http://i.imgur.com/dUo4xDo.png)