Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
How to add rows in data set.
Currently we have data in Pivot table:
and we have to show like below:
it is one of the dimension for ex: Dim1 and Expr: Sum(Sales)
and we have to do in front end only, it is not possible to do in script part.
- Priya
Do you want to add blank rows? Or just split the column into 2 - separating the number?
Why do you need this?
I need just 2 blank rows
sorry it is straight table
Is it just the space you need between the rows? if so you can add chr(10) to add a line break;
Example.
=sum(Sales) & chr(10) & chr(10)
I don't need spaces and I need rows in between 3 and 4 as shown in the image
If it's just for aesthetic reasons another solution could be to wrap the cell text to increase the space between each value. Go to presentation tab > multiline settings and tick the wrap cell text checkbox and then increase the number of lines to suit your requirement.
we have specific reason to add blank rows, so we need it...
Unfortunately, there isn't a way to accomplish this in the front end alone. A straight table will display a row for each unique dimension+expression. If there is no dimension, then it cannot display a row.
There are alternatives though, you could add dummy rows in the script and make the text of those rows match the background.
Script: if(Previous(Row)=3 OR Previous(Previous(Row))=3, 1) AS Flag.Blank
Table Background: if(Flag.Blank = 1, White())
Or you could Inline Load a table with Row numbers like 1, 2, 3, 3.1, 3.2, 4, 5. Then your background expression could read if(Row>3 AND Row<4, White()).
As a last resort, you could use an external Excel file to control the table's format, but you can't add a row where there isn't a dimension to display it in the front-end alone. Sorry