Max Value in Pivot

Lifesigns — Mon, 24 May 2021 15:40:48 GMT

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

Re: Max Value in Pivot

chrismarlow — Mon, 24 May 2021 18:14:04 GMT

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.