1 Reply Latest reply: Jun 13, 2016 3:03 AM by Marcus Sommer RSS

    sum of all the columns group by project name ?

    anand ranga

      I have  a table like this:


      project_name      janExp      febExp      marchExp      aprilExp

      project A           1000           1100          1200              1300

      project B           2000           2100          2200              2300

      project C           3000           3100          3200              3300

      project A           500             600            700                800

      project B           100             200            300                400

       

      I want output like this:

      project_name          janExp      febExp      marchExp        aprilExp

      Project A                1500           1700           1900             2100

      Project B                2100           2300           2500             2700

      project C                3000           3100           3200             3300

       

      I am new to Qlikview,  can someone tell me what I need to do for it?