Reporting from a Cube - Rollup Issue

[andy_mason_84]

Hi All,

OK I have a Category Count Measure in the cube that counts the amount of Employees for example: -

Employees Count in the cube displays as: -
A 1
B 2
C 2
D 15
_____
Total 15

Which is correct there are 15 employees but some of them work for more than one department.

Where as when reporting from the cube in Report Studio just adds up the figures, it seems you can;t do count distincts like you can when reporting straight from the framework. 
A 1
B 2
C 2
D 15
_____
Total 20

Any ideas how to resolve this and get the total to be 15 in report studio.

[PaulM]

The problem is the way you're doing the roll up. My guess is that you're doing something like total([Employee Count] within set [DepartmentLevel]) Try changing that to aggregate([Employee Count] within set [DepartmentLevel]).

[andy_mason_84]

Fantastic

Thanks.