Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you made this horizontal table using slice and dice??
no. never heard of it. is it like a drilldown? could you give me an example? thank you
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.
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.