Pivot table dimensionality

[sankar_ganesh]

Product_Category	Product	Sales
X		10
X	A	20
X	B	30
X	C	0

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.

Regards,

Sankar

[veidlburkhard]

Hi Sankar,

no problem, this is easy. See the picture below

Hope this helps

Burkhard

[sankar_ganesh]

Hi Burkhard,

Thanks for your inputs. I want to highlight the row which do not have any 'Product' value (i.e. having '-') in the red background as shown in the screenshot I have given.

Regards,

Sankar

[jagan]

HI,

Try this in BackGround Color

=If(Len(Product) = 0, RGB(255, 0, 0))

Regards,

Jagan.