Add an indent to the visualization Table

[lucasfioravanso]

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 !

[justISO · Accepted solution]

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]

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!!

[justISO]

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

Repeat(Chr(160), nr_nivel) & cd_conta_contabil