Show and Hide Subtotal in Pivot Table

[Anonymous]

Currently I create 2 pivot table: 1 with show partial sum is checked, the other is not.

But I'm having problem when I tried to change column position in non subtotal table, the subtotal table won't automatically change the column position (Of course, since it's 2 different tables).

Below is the example. I tried to move QuarterYear into horizontal position.

But when I click subtotal, the QuarterYear is not moving.

Is there any way to make this 2 tables correspondent? or is there any other way to achieve this?

Btw, I tried to make duplicate dimension instead of 2 different tables to show/hide subtotal. but it still doesn't solve this problem

Thanks in advance

[prasoon92]

Have you made this horizontal table using slice and dice??

[Anonymous]

no. never heard of it. is it like a drilldown? could you give me an example? thank you

[prasoon92]

Create quarter year as normal vertical column and then slice and dice.

Process:select the column and try to roll that column in the circular way . It will automatically get converted into horizontal column.

[balabhaskarqlik]

To move columns within the pivot chart, you need to tick the "Allow Pivoting" option on the Presentation tab, so try with this option also.