If you want to remove all your value fields from your pivot table – you should not do this by removing the fields one by one.
Instead of removing each field from the Values area in the PivotTable Fields action pane one by one – simply remove the Values field in the column or rows area.
Instead of removing each field from the Values area in the PivotTable Fields action pane one by one – simply remove the Values field in the column or rows area.
That will remove all your value fields from the pivottable.
Hope this little trick can help you too.
Pingback: Excel Roundup 20151130 « Contextures Blog
So simple, it’s brilliant. Thanks 🙂