Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasfioravanso
Contributor II

Add an indent to the visualization Table

Hi guys, how r u?

I need to add an indent to the visualization, like the one in the attachment. How can I do this? If the account is level 1, there is one space, if it's level 2, there are two spaces, if it's level 3, there are three spaces, and so on.

Object: Pivot Table

Thanks all !

Labels (3)
1 Solution

Accepted Solutions
justISO
Specialist

Hi, have you tried in Pivot->Appearance->Presentation check both ticks in 'Fully expanded' and 'Indent rows'?
Other workaround would be to use function Dimensionality(), but this require to edit all your dimensions something like this
=Repeat(Chr(160), Dimensionality()) & [your_field]

(it repeats 'space' character as many times as there is Dimensionality of row and adds your dimension value)

View solution in original post

3 Replies
justISO
Specialist

Hi, have you tried in Pivot->Appearance->Presentation check both ticks in 'Fully expanded' and 'Indent rows'?
Other workaround would be to use function Dimensionality(), but this require to edit all your dimensions something like this
=Repeat(Chr(160), Dimensionality()) & [your_field]

(it repeats 'space' character as many times as there is Dimensionality of row and adds your dimension value)

lucasfioravanso
Contributor II
Author

My code:

If(nr_nivel = 2,Repeat(Chr(160), nr_nivel),
If(nr_nivel = 3,Repeat(Chr(160), nr_nivel),
If(nr_nivel = 4,Repeat(Chr(160), nr_nivel),
If(nr_nivel = 5,Repeat(Chr(160), nr_nivel),
If(nr_nivel = 6,Repeat(Chr(160), nr_nivel),
If(nr_nivel = 7,Repeat(Chr(160), nr_nivel),

)))))) & cd_conta_contabil

It's works. I really appreciate it, thanks!!

lucasfioravanso_0-1673444647687.png

 

justISO
Specialist

Instead of long if, I believe this do the same:

Repeat(Chr(160), nr_nivel) & cd_conta_contabil