row and column Automatic switching

Fri, 18 Jan 2013 05:25:33 GMT

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

Re: row and column Automatic switching

Fri, 15 Mar 2013 11:29:11 GMT

Hi,

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

Regards,

Nirmal