1 of 1 people found this helpful
Your 'FY' field is currently an integer, with two values 2016, or 2017. I'm guessing that your underlying data source is an excel sheet, which formatted these numbers as integers, when they should be considered date fields, as they hold a value that translates to a given year. I would recommend changing this to a date just as a best practice for starters.
In terms of your actual issue, what I would suggest would be to set up a parameter for the FY field, that would hold all the years in the data set. You would then use the 'Condition' tab within your suppliers top 10 filter to filter out the dates you don't want to see. I'm assuming these dates are 'Fecha de inicio', 'Fecha de reporte', or 'Fecha factura si no es...' and hold some significance to your data. This would work by setting the condition equal to:
[FY Parameter] = [Selected date field]
The top condition would remain the same, but with this condition in place, it would only take the top from your given FY in this case.
If this is unclear, please convert the FY field into a date field (as when I try to it tells me I don't have permission to, because I don't have your original excel sheet) and re-attach your notebook.
Thanks, I converted FY to string type and in the filter frame added it to context, also the dimension of "diferencia en datos" and it worked
Glad I could help!