Forum Discussion
Insert a blank row in matrix visualization
Hello,
Here is a scenrio. Any help is appreciated!!!
I want to insert a blank row btween my each instance of group in matrix visualization.
Please refer to the below snapshot. Currently when I use matrix, "C2" details are printed from the next line. I want the blank row as show in the screenshot just before details of "C2".
| Category | Product | Amount |
| C1 | P1 | 1000 |
| P2 | 1500 | |
| P3 | 1800 | |
| C2 | P4 | 1200 |
| P5 | 1300 |
Thanks,
Ankit
19 Replies
Hello,
Add a new blank row to your category column and make sure it is ordered to be between C1 and C2. Ensure that the matrix is set to show that new category. Then right click the category field on the matrix visuals rows section and select "show items with no data."Now available but only for the top category
Hello,
Here is a scenrio. Any help is appreciated!!!
I want to insert a blank row btween my each instance of group in matrix visualization.
Please refer to the below snapshot. Currently when I use matrix, "C2" details are printed from the next line. I want the blank row as show in the screenshot just before details of "C2".
Category Product Amount C1 P1 1000 P2 1500 P3 1800 C2 P4 1200 P5 1300 Thanks,
Ankit
I am not aware of a way to do that.
could you use a union statement to add a blank row?
Hello,
Union is used to create a join of two tables. Are you suggesting to take a blank table?
Can you please explain.
Thanks!!
Hello ,
Category C1 is appearing only once, in my case its appearing for each row.
Can you please help me how to achieve it.
Thanks.
Here's a workaround:
- Choose a matrix visual
- Add a subtotal row
- Empty its name (usually "Total")
Then, you have to modify your measure:
IF(HASONEVALUE([Product]),[Amount],BLANK())I just created a new measure of whatever (count of x = 1) and formatted the text and the background accordingly - quite happy with it. FYI, I'm not totalling my rows.
