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.