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 hav...
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.