Forum Discussion
TP700
Aug 30, 2023Copper Contributor
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
That could be done if add data to data model, generate proper DAX measure and create PivotTable based on data model.