Forum Discussion
Unable to stop values field from calculating in pivot tables
Hello. I’ve created a pivot table where all the other fields are set up correctly. However I am unable to just include data in the “values” without it performing a calculation. Tried multiple times t...
The Values area of a PivotTable is inherently an aggregation area. Move the field to Rows or Columns to list records, then use Design > Report Layout > Show in Tabular Form. If the goal is simply a filtered list, keep the data in an Excel Table and filter the source instead of forcing a PivotTable to behave like a raw-data view.