row and column Automatic switching

[#1]

hi

qv11,in pivot table，row and column Automatic switching ,I can't find a way to set it ，Are there any other methods? thanks!

[#2]

hi

i use "NumberOfLeftDimensions" to control the pivot table,follow：

expected structure：

don't want users drag the BLANK label with mouse。

I can't find a way to set it ，

Are there any other methods? thanks!

see att qvw file