Forum Discussion
How to select multiple columns of my choice to display in Pivot Table?
How to select multiple columns of my choice to display in Pivot Table?
I have data in columns A to Z. I want to create a Pivot Table which should contain the columns A, F, S, T, X only. Do we have any option in Excel spreadsheet to perform this action?
1 Reply
Not sure I understood the question. With PivotTable you show not columns from source data, but their aggregations (sum, average, min, etc) and in which form to show (no calculations, % of total, etc) plus that could be calculated fields or DAX measures. Lot of options which you may define in PivotTable fields pane.
