aggregation result

[#1]

How can I show count of aggregatad results??

I have a dimension employee

and

expression Sum(worked hrs)

now I want to count aggregated result in other expression irrespective of any selection.

1st expression Sum(worked hrs)

and In my 2nd expression

It is something like that count(Sum(worked hrs))

any help??

Regards,

Bab Tech

[Anil_Babu_Samineni]

Try this?

Count(aggr(sum([Worked Hrs]),Employee))

[tresesco]

Not sure if understood right.

If you have n employees, you would be getting n number of aggregations. That is if you want to count the number of aggregations - that would be eventually distinct number of employees which you can get using count(Distinct employee). If you want to get the total number against all the employee rows, you might have to use count(Distinct TOTAL employee).

[Anonymous]

Hi Babi,

Can you pls share some sample data so we can work on that . Currently its difficult for me to understand your requirement.

Thanks,

Pooja