5 Replies Latest reply: Oct 28, 2014 6:21 AM by Sankar ganesh Thiagarajan RSS

    Pivot table format

    Sankar ganesh Thiagarajan

      Date

      ProductSales
      27-Oct-14P110
      27-Oct-14P15
      28-Oct-14P120
      28-Oct-14P130
      27-Oct-14P220
      27-Oct-14P215
      28-Oct-14P220
      28-Oct-14P240

       

      Hello,

       

      Above is the sample source  data of my qlikview report, from which I need to create the table given below.

       

      Here Sales is the sum(Sales) of the source data and the difference is the diff. of Sales b/w the two products. Is this possible ? Could some one give suggestions .. Thanks!

       

      P1P2Differrence
      Sales659535

       

      Regards,
      Sankar