Background Color for Full Row is not working in Pivot Table

[sakthi266]

Hi Team, 

            I am working on Pivot table with two dimension and one expression. I am moving one dimension from vertical to horizontal then it is showing with Space. Is it possible to remove that space. Please refer the attachment 

1. Data in first sheet.

2. Showing as sheet 2 

But required as mentioned in the sheet 2 below 

Regards, 

Sakthivel.S

9843527174

[AshutoshBhumkar]

Hello,

As there are not blank spaces or nulls in your data, Blank space should not come in Pivot.

Could you please provide some Qlikview table screenshot ?

Thanks,
Ashutosh

[ramasaisaksoft]

if you have Null Values in your data then you can ignore (Suppress when Value is Null)those in Dimensions.

if you want Background ground color for a table /For each Row

Pivot Table--> Properties-->Style-->Current Style (Drop down list )--> select Pyjama Green-->Stripes every 1 Row.