7 Replies Latest reply on Oct 30, 2018 11:11 AM by rosie chi

    Sorting sets created with Top N

    rosie chi

      Hi there,

      I have a set that is created with Top N condition sorted by the sum of the field with data filtered to 2017 only (this is the top 15 products in desc order of sum of sales).  I would like to use this set to create a trend from 2016 to 2017, but I also want both tables to match up so that they can be shown side by side (sort order of the products by total sales in 2017 is the same order as the table that shoes its trend).  So in effect, I would have the following columns:

       

      | Product | Total 2017 Sales | Sales Trend from 2016 |

       

      How can I keep the sort order the same for the trend as for the Top N?