Worksheet: Pivot to keep original selection

VickiToy

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.