5 Replies Latest reply: Aug 1, 2017 5:50 AM by Tomasz Truszkowski RSS

    cross table problem

    Dave Lau

      Hello everyone

       

      plz look at my source data first

      微信截图_20170801162148.png

      I would like to load it by cross table function , here is my script

      微信截图_20170801162333.png

       

      then I got the result as below

      微信截图_20170801162248.png

       

      Model "C" and "D" just disappeared because they contains no value , but actually I need to load them into my qvw file and just leave the amount as null

       

      how should I change my script ? plz help . thx ~