Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table with two dimensions: employee name, task name and then expressions are sum(task_time) and sum(forecast_time).
What I need to show is which of their tasks is taking the longest in a separate expression.
For example:
John Doe has booked 30hrs against 7 different tasks, the largest is 'Investment Time' so in another expression I need to show that it took 20hrs.
The tasks vary across all the employees.
Advice be appreciate...
Thanks,
Shane
Hi,
Might take a bit of fiddling, but try something like;
max(aggr(sum(task_time),[employee name],[task name]))
FirstSortedValue([task name],-aggr(sum(task_time),[employee name],[task name]))
So like below;
Cheers,
Chris.