Pivot Table fixed dimension

[Anonymous]

Hi all,

how can i fix a certain Dimension in Pivot Table?

Example:

Hierarchy_Lvl 1	Hierarchy_Lvl 2	Date	Fact
abc	abc_2	12-24-15	145
def	def_2	12-24-15	1864

The Hierachy can be expanded. But the Date-Dimension Column should always be visible. Regardles how "deep" the nodes are expanded.

-phil

[Gysbert_Wassenaar · Accepted solution]

No, that's not possible. Either all dimensions are always fully expanded or all dimensions can be collapsed and expanded.

[#3]

You can't achieve that in Pivot object. only work around I would advise is, If you will have always only one date under the combination of Hierarchy lvl 1 & 2 then you can add the date column as an expression.

But this doesn't work if you have more than one date under each level1 & level 2 combination