fix dimension horizontal and expression vertical

[wenkew186]

Hi expert,

I have a pivot table,5 dimensions, 2 expression.

The 5 dimensions is dynamic add by select name in list box. it means the dimension can be 1 or 2 or 3... or free combination.

now I want,

make the dimension to horizontal, expression to vertical,  switch seat.

I found it can be drag to change, but it can't fix in seat when I re-select different dimensions. it will back to vertical.

is there any way to solved it?

thanks a lot,

Kevin.

[kristof_j]

Hi Kevin

Can you give us an example qvw?

[Siva_Sankar · Accepted solution]

Enable option 'Always Fully Expanded' under presentation tab.