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
1 Reply
- SergeiBaklanDiamond Contributor
That could be done if add data to data model, generate proper DAX measure and create PivotTable based on data model.