2 Replies Latest reply: Oct 26, 2016 7:33 AM by MASSIMO FIORINI RSS

    Sort Pivot Table in Qlik Sense

    Matias Milletari

      Hi, I have a pivot table with the following structure (the measure is Total Sales):

       

      20152016
      Customer 1Product A$ 40,000$ 3,000
      Product B$ 35,000$ 50,000
      Product C$ 70,000$ 6,700
      Customer 2Product A......

       

      Is there any way to take sort the rows of products according to the sale during the year? Ie take 2016, and to order the items according to the total sold (C, A, B), and then to do the same with 2015 (B, C, A). I can not find how to sort the table according to the measure.

       

      Thanks!