Forum Discussion

hylosko's avatar
hylosko
Helper III
5 years ago

Topn problem, idk

Hello everyone i have one problem:

 

I have table with 3 values [Order created by user], [order to delivery duration (time)] , [ Order number]

 

i use topn botton 10 filter to [order number] by value [ [order to delivery duration (time)]  and its works, but i see on different plants, more than 10 value in my topn botton 10, sometimes its 13, 14, 17

 

i can also see that  [order created by user] have more than one [order number] which contains two or three different [ [order to delivery duration (time)] 

 

how to solve that ? i want to see only botton 10 values, no more

Need Help

2 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi,  hylosko 

    From your screenshot, your [order number] contains multiple duplicate values.

    You'd better to add a Index column.Then you can use topn botton 10 filter to this Index column by value  [order to delivery duration (time)] .

     

    Best Regards,
    Community Support Team _ Eason