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.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!