How to fill empty cells of 2nd dimension with 1st dimension value in pivot table or in Table in Qlik

[SatyaPaleti]

Hi Folks,

I am having a following requirement. I am having two dimension and one measure.  I just want to know how can we fill the empty cells of 2nd dimension with 1st dimension value

Currently I am getting chart like this

As you can see last product 'Projector' it doesn't contain any brand. So we need to see the data which should be fill with 1st dimension in the 2nd cell. We dont want to see empty cells. It should cover with 1st dimension value like in the below screenshot

As you can see Finance Mix & Revenue Mix don't have sub dimensions. Then it had filled in 2nd dimension cell. we need to see the report in the same manner

Could some one can help me to resolve this. Here is the sample data

load * inline [
Product,Brand,Sales
Mobile,Samsung,23
Mobile,Apple,22
Mobile,Oppo,12
Laptop,HP,13
Laptop,Lenova,14
Laptop,Apple,18
Projector,' ',26
];

Thanks and Regards,

Satya

[y_grynechko]

Hey,  use the if in the 2nd dim.