Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this?
Count(aggr(sum([Worked Hrs]),Employee))
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).
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