9 Replies Latest reply: May 23, 2014 8:33 AM by Dariusz Mielczarek RSS

    Pivot Table

      Good day,

       

      I have table as a below:

       

      Capaicty

      Premium

      5

      2

      10

      4

      8

      6

      7

      8

      12

      5

      4

      7

      5

      9

      9

      11

      8

      13

      15

      15

      12

      17

       

       

      I need to crate table in qlikview like this:

       

      Capaicty

      Premium

      1 -  5

      18

      6 -  10

      42

      11 - 30

      37

       

       

      In excel I can use sumif to create table. Here I could not create. Please, help me

       

      Thanks in advance