Returning to a Pivot Table for Advanced Operations
Returning to a Pivot Table for Advanced Operations
Pivot tables are very powerful. A subset of pivot table operations are available in the pivot
chart interface. Sometimes, however, you need to return to the pivot table in order to carry
out an advanced operation. After you have made the change to the pivot table, you can then
click the pivot chart in order to return to the pivot chart interface.
One example of an advanced operation is grouping daily dates up to months and years.
Because the underlying data is transactional, it is reported at the daily level. If you build a
pivot chart with dates ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.