This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Sort 5 top

Posted on 09-04-2022 04:41 AM
Mouldi_Zeghouan
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hi,

I got some issue to extract the 5 top count companies with the status (Postpone).

I created the slice name Top Sort and  connected it to the main data name (Data), i used the expression  in the Row filter condition:IN([ID], TOP(ORDERBY(Previous Month [ID], [Status], FALSE), 5))

Previous Month: slice showing the previous month

Status: Enum column with the  two options : Postpone, Proceed

I tried many  expressions but the results were still wrong. 

Please advice

  

 

0 5 155
Topic Labels
0 Likes
5 REPLIES 5
Top Labels in this Space