Forum Discussion

eden's avatar
eden
Icon for Helper I rankHelper I
6 years ago

Report: How to display TOP 5 Result based on Status ?

Hello  i got a sharepoint list similar to follows    Workorder Status customer  start date One published abc 01/08/2020 two reviewed def 24/09/2020 three waiting xyz 17/09/...
eden's avatar
eden
Icon for Helper I rankHelper I
6 years ago

How to use the below solutution 

 

Axis : Customer 

Value : Top 4

 

 

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

eden 

Yes, you are right.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

  • eden's avatar
    eden
    Icon for Helper I rankHelper I
    6 years ago

    Fowmy 

     

    Its not doing for me .. i am getting something like below

     

     

    settings

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      6 years ago

      eden 

      You may have more than one customer who falls into the top 4. If you have two customers who are ranked top one, they both come.

      ________________________

      If my answer was helpful, please consider Accept it as the solution to help the other members find it

      Click on the Thumbs-Up icon if you like this reply 🙂

      YouTube  LinkedIn 

      • eden's avatar
        eden
        Icon for Helper I rankHelper I
        6 years ago

        Fowmy 

         

        that can be the case.

        how to filter them based on any other criteria.. We can use start date , that whoever has early entry can be displayed in the chart