Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement where I need to have blank rows inserted in a straight table. I should use only a straight table but not a pivot table. Please suggest any ideas to achieve this.
Concatenate nore rows of data to your fact table with inline load . Flag that data with a field. Set text of that data to match background color of your table using flag created earlier
Thank you rawat.
But the thing is that the blacnk rows should be coming in between. Say at the end of each primary dimension value.
If i add inline, what would be my approach to sort the table so that the blank rows comes in middle.
hello
you should create a field used to sort your data
and manage to create adequate keys for your blank lines