Finding the Adaptive Element (9)-A numeric combination of pivot tables

Finding the Adaptive Element (9)-A numeric combination of pivot tables

Design essentials: excle, interface, auto-adjust, pivot table

Kim : "smart"?! Ah, I have not heard you so much praise me for a long time.

Xiu Xiu : Because such a combination is too common.

Kim : There are more commonly used combinations of numbers.

Xiu Xiu : Right, how to use?

Jin: For example: the row label area and the value area are Amount fields, right-click in the PivotTable-Combo dialog box, start at position enter 0, the stop at position remains unchanged, the step value remains at 1000, click OK You can automatically press each 1000 combination as a group.

Xiu Xiu : Oh ...

Kim : How about that? Very powerful, huh?

Xiu Xiu : Well,--Not You "smart", is the pivot table "smart"!

Finding the Adaptive Element (9)-A numeric combination of pivot tables