Forum Discussion
Insert a blank row in matrix visualization
But the blank line is supposed to be between each category row in a matrix visual. A blank line in a data table won't have any affect on that.
it will if you create it with a category and blank products
I tried your suggestion by adding a blank row in table. The row has value "C1" for "Category" and other fields are blank.
It's not working.
was worth a try, maybe put a white space in it? dont know if that will help though. when you say it doesn't work, what exactly happens? Did you create all the columns, i think you need all the columns present for a union
what are you actually trying to do though, just create space as in formatting?
I have inserted a new row in my excel sheet. I have only inserted value for "Category column" and rest columns are blank. Please see below for reference:
Category Product Amount C1 P1 1000 C1 P2 1500 C1 P3 1800 C1 C2 P4 1200 C2 P5 1300 Now I am trying to display this data in matrix. I have added "Category" and "product" to my "row" section and "Amount" to "values" section.
It;s showing the data perfect except a blank row between C1 and C2 grouping. I have attached snapshot of output as well. See if it helps.
