3 Replies Latest reply: Jun 23, 2014 3:41 AM by jagan mohan rao appala RSS

    Pivot table dimensionality

    Sankar ganesh
      Product_CategoryProductSales
      X10
      XA20
      XB30
      XC0

       

      Hello,

       

      By loading the above table data as a source, I have created a pivot table in a qlikview report as shown below. Now I need to display the row , highlighted by the blue rectangle below, in the red background , the rule is to show that 'Product category' row in red background when there is a Product(2nd column) under that category  having sales =0. Here the Product C has zero sales , hence that Product Category row needs to be shown with the redbackground. Is it possible ? Can anyone help.

      Capture.JPG.jpg

      Regards,

      Sankar