Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hey, use the if in the 2nd dim.