Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a Pivot table with Dimensions Manager, customer, Salesperson, City and with Expression Total Sales. This is a Default chart in all the tabs, as per user requirement I have to change the order of the Dimensions like City, Customer, Manager, salesperson.so now without changing the order of previous pivot table I have to show the current requirement using Button.
If I click on the Button the Order of the Dimensions should change automatically within the same pivot table without creating the macro and second pivot table otherwise default pivot table remains same
Thanks
Why not just drag the dimension columns around as needed by the customer?
That Pivot table cant be change it should be remains same when they click on button it has to change as per requirement.
Maybe I'm missing something, possible solutions are:
a) drag columns (no, you don't want this)
b) Create multiple charts with different dimension order, show / hide conditionally by button (no, you don't want a second chart)
c) Change dimensions by macro (no, you don't want that)
d) last thing I can think of: Create 2 cyclic dimension groups identical with all 4 dimension fields, use these groups, then the user can change the order of dimensions by cycling to appropriate dimension in each column.
Hi,
one solution might be also:
hope this helps
regards
Marco