Dimention and Grouping

[#1]

HI All

                         for the below expression

=if(sum( distinct EmployeeBucket )>36 and sum(distinct EmployeeBucket )<=70,Count( DISTINCT [Employee Number]))

I am using Employee band as expression but i want the sum(distinct employeebucket) to be calculated for each and every employee on that group separately

Please help

[marcus_sommer]

Maybe a calculated dimension with clusters about your EmployeeBucket is helpful for you:

Class(aggr(sum(distinct EmployeeBucket), Dimension1, Dimension2), $(ClusterSize), 'x', 0)

- Marcus