Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a variable called $VTop to pull the top 10 from a variable input box.
The variable is part of the ranking formula
Aggr(rank(sum(Value),$(Vtop)),Function,Name)
While it ranks the data, The variable input does not recognize the input.
I am new, so I just tried to figure things out, but they are not working.
Any help will be greatly appreciated.
Could u share a demo file?
Best regards Son
Thank you. Here you go
Hmm, maybe
try something like this:
Aggr(rank(sum(Value),'$(Vtop)'),Function,Name)
or this:
Aggr(rank(sum(Value),$(=Vtop)),Function,Name)
Could you also show how the editor interprets it?
Thank you very much for your help. Both Formulas only ranked the result. On the print screen, you can see those outliers in Red are still listed. I would like it to exclude them when the Top 1 or 5 is input in the variable input. Now, it does not do that. You can see I input zero, and it just ranked the entire population.
I think i understand your problem:
Try something like this:
Sum( {<Name={"=Rank(SUM(ID),4)<=$(vTop)"}>} ID) Or in your case i guess something like this will help:
Sum( {<EmployeeName ={"=Rank(SUM(RecoveryKey),4)<=$(vTop)"}>} RecoveryKey)
Best regards Son
You are surely taking me in the right direction. But I will need a function as part of the calculation.
I have been following the Top N the example on YouTube, but I guess I lost.
While the example only looks at Brand and Sales
In my example. I group Function, Name on Sales
When I do the of
Rank(Sum(Sales), Function, Name)<=10
It tested for -1 and 0. -1 means the Sales falls within the Top 10
However, when I try to bring the actual result so I can use variable input, it does not work.
This is what I am using to try to filter the column for only the Top 10
Sum(
{<
Function, Name={“= Rank(Sum(Sales), Function, Name)<=10
”}
>}
Sales)