8 Replies Latest reply: Jan 7, 2014 4:29 PM by Massimo Grossi RSS

    Pivot table help

      Hi All,

       

      I have a requirement where I need to display a Pivot table having dollar values for the following values of one Dimension.

       

      Product1Amount
      Sales76215.5
      Direct52044.86
      Indirect89573.6
      Marketing93449.1
      Direct6554.309
      Indirect19710.01
      Product241871.07
      R&D26531.7
      Direct48975.56
      Indirect48590.39

       

      and so on.

       

      The problem that QlikView sees the repeating values in the Dimension and clubs them all together, so my Pivot table looks like the following:

      Product1Amount
      Sales49825.05
      Direct172573.6
      Indirect253675.1
      Marketing11201.1
      Product266014.51
      R&D86477.5

       

      The values of Direct and Indirect are being summed up and shown in one row respectively.

       

      How can I make QlikView show it as individual values in the Pivot chart??

       

      Thanks,

      Abhinava