row and column Automatic switching

[#1]

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

[#2]

Hi,

I cant get your point but i done one thing pfa hope this is helpful

Regards,

Nirmal