Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Issue with top20 items

Hello

 

I will greatly appreciate if someone can help me.  

 

I have unit number of their forecast. I want to see also top 20 items (not a %, items). 

When I select week 10/3 I have 20 items, everything works fine. Great!

When I select week 10/10 I have 20 items, everything works fine. Great!

However, when select both week from a slicer, it gives all 40 items. I want only 20 items to be appear (whichever the forecast amount is greater).

 

Filter type: TOP N

Show Top 20

By value: Total Forecast

 

 

 

 

 

Need Help

1 Reply

  • collinq's avatar
    collinq
    Super User
    4 years ago

    hi Anonymous ,

     

    First, thanks for the screenshot, very helpful in my thought process.

     

    I am wondering about the connection of the Date field to the table.  Is this a Date Dim?  Is this Datefield called "Start Date" coming from the same table that you are using to rank? What happens when you put that Date Field into the table?