Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a straight chart that has [Task] as demension and as experessions has [Number of tasks] , [Rank by number ], [Time to complete], [Ranked by time to complete].
There are a shedload of tasks, I have them sorted by [Ranked by time to complete]. I wish to only show the top 5 of Number.
So using the below sample data = It would show all tasks as far as Pinch as thats the last task in the Top 5.
Is that possible
Thanks
A
Number | Rank # | Task | Time | Rank Time |
70 | 5 | Eat | 100 | 1 |
80 | 3 | Drink | 90 | 2 |
55 | 6 | Be Merry | 80 | 3 |
90 | 2 | Dance | 50 | 4 |
15 | 7 | Fight | 40 | 5 |
100 | 1 | Clean up | 30 | 6 |
77 | 4 | Pinch | 25 | 7 |
2 | 9 | Cook | 20 | 8 |
10 | 8 | Tidy | 15 | 9 |
Actually now I think about it , its probably how I write the expressions
so sum Number only if Rank time is greater than 5
=sum(if(rank(sum(Number)*CycleTime/60)>5,Number))
I've tried the above - it doesnt work - any suggestions greatly appreciated
Thanks
A
haha Me again
if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())
The above works as in it will only sum when it is ranked in the Top 6 in either Rankings
But now is there a way to hide the row if the value is Null in the Sum Number column?
Thanks
A
haha Me again
if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())
The above works as in it will only sum when it is ranked in the Top 6 in either Rankings
But now is there a way to hide the row if the value is Null in the Sum Number column?
Thanks
A
haha Me again
if(rank(sum(Number)*CycleTime/60)<6 or rank(sum({1}Number))<6,sum(Number),null())
The above works as in it will only sum when it is ranked in the Top 6 in either Rankings
But now is there a way to hide the row if the value is Null in the Sum Number column?
Thanks
A