Pivot Table - % totals and only showing 1 sum

[welndmn]

I have pivot table like the following.
It's just counting the work orders and the field values is the % of the row total.
The issue I can't seem is fix, is I only want to show the "Late"s. I want to chart only the lates, but how to I calculate the row total without have the early?
this is easy in a normal chart where I can select the ranges to chart, but how can I do this in a pivot table?

	Car1		Car2		Car3		Car4		Grand Total
Row Labels	Early	LATE	Early	LATE	Early	LATE	Early	LATE
2019
Jan	3.45%​	0.00%​	58.62%​	3.45%​	13.79%​	6.90%​	13.79%​	0.00%​	100.00%​
Feb	12.50%​	0.00%​	37.50%​	12.50%​	18.75%​	0.00%​	18.75%​	0.00%​	100.00%​
Mar	5.00%​	0.00%​	55.00%​	5.00%​	15.00%​	15.00%​	5.00%​	0.00%​	100.00%​
Apr	10.00%​	0.00%​	55.00%​	5.00%​	10.00%​	0.00%​	20.00%​	0.00%​	100.00%​
May	9.52%​	0.00%​	47.62%​	0.00%​	23.81%​	0.00%​	19.05%​	0.00%​	100.00%​
Jun	4.35%​	0.00%​	43.48%​	8.70%​	39.13%​	0.00%​	4.35%​	0.00%​	100.00%​
Jul	15.38%​	0.00%​	46.15%​	3.85%​	15.38%​	3.85%​	15.38%​	0.00%​	100.00%​

 

[pjmorris]

I believe you're having this issue because you're using an original PivotTable, you need to use PowerPivot where you can write 'measures'. The measures don't themselves need to appear on the pivottable, but can be used in calculating other measures which are themselves visible on the PT. As an example the normal sum of values which is shown when dragging data to the values area would be written as an explicit measure like this: SumOfData=SUM(tblName[ColumnName]). SumOfData can then be used in other measures.

You probably need to read PowerPivot and PowerBi by Rob Collie and Avichal Singh (its where I learnt everything I know). It will take you longer than some devious trick with your original data table, but ultimately you will be well rewarded with a significant improvement in your Excel prowess.

HTH