
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 !
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Instead of long if, I believe this do the same:
Repeat(Chr(160), nr_nivel) & cd_conta_contabil
