add rows in data sets

[priyarane]

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

[boorgura]

Do you want to add blank rows? Or just split the column into 2 - separating the number?

[ThornOfCrowns]

Why do you need this?

[priyarane]

I need just 2 blank rows

[priyarane]

sorry it is straight table

[ThornOfCrowns]

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)

[priyarane]

I don't need spaces and I need rows in between 3 and 4 as shown in the image

[Anonymous]

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.

[priyarane]

we have specific reason to add blank rows, so we need it...

[ciaran_mcgowan]

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