Good Day, All
Is it possible to hide rows in pivot table if drill down level have same name (or empty). It should not depend on measures.
For example, table:
level1, level2, level3, level4
a,b,c,c
1,1,2,3
e,d,f,g
,,y,z
I want to see the pivot table with following indented rows (without repeating or empty levels):
a
- b
- - c
1
- 2
- - 3
e
- d
- - f
- - - g
y
- z