Forum Discussion

TP700's avatar
TP700
Copper Contributor
Aug 30, 2023

Pivot Table adding too many columns

Hello, I have a pivot table which looks at invoices in our business, who is responsible for them and whether they are within an agreed SLA we have. I am trying to add in a total column which shows the percentage of invoices employees have outside of SLA, but it adds the percentage to each section, is there a way to only have this percentage show right at the end looking at the total volume rather than each section? Thank you

  • TP700 

    That could be done if add data to data model, generate proper DAX measure and create PivotTable based on data model.

Resources