IBM Business Analytics

I am creating a report using the performance of seller through time, selecting the sold amout of a day and using total-moving i get the previous day amout and calculate the difference. After that i need to clean the empty rows and order the data based in the difference, but i can't filter the rows after the process or order the data based in a calculated column.

I want to know if there is a better way to do that or if filter after the process or if i can duplicate the data and filter after the process

To use as example i have this spreadsheet

And i need to transform the data above into this

Hi Gabriel,

Based on your data, you might want to create a filter with the following expression:

[Date] = maximum([Date] for report)

where [Date] is the column name for Date.

Best regards,