I would like to add that that it was proposed to use parameter of some sort but I am unsure how
the solution you have provided does work but I need to use the ranked "Customer" to filter line graph on other sheet.
and the same rank calculation doesn't copy the values from main sheet
one using plane data with numbers the trick works brilliantly
thanks for your support.
Hi Zhouyi Zhang
Thanks but not really..
this sample file is not perfect as the rank is not really working...due to multiple values per rank...
in the data set I'm working with I need to rank all the values based on shipment number per site
and then for top 5 sites produce detailed breakdown for number of items per shipment so how many shipments of 2 items 3 items 55 items and so on..
but I would like to filter each set based on the position in the ranking.. so sheet 1 will always show breakdown for site positioned 1st sheet 2 for the one in position 2 and so on...
I'm trying to do the same in excel using pivot table on data set downloaded as costab but failing there too
For this viz you will need the rank pill on the columns shelf.
Can you re-upload your viz with where you have gotten up to so I can take a look ?
Hi Peter Fakan
as much as I would like to I can't both due to sensitivity of data and size of it.
I know how to do top 10 or top 5 etc. problem is to select only the 5th one to be displayed
I may have to try and recreate it in excel and do some filtering between sheets isind values from specific cell ( Call B3 will always have 2nd top value etc.)
but really wanted to add this feature to current dashboard we are using