Worksheet: Pivot to keep original selection

You can only pivot on an Custom view. However you make the selection of the line items that you want the end user to see. As there might be calculation items, formatting or headers. However when the end user pivots all items come available that make no sense to the end user. Would like to keep the original selection or have pivot available on Saved Views.

1 votes

New · Last Updated

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!